PL/SQL functions in SQL statements may cause major performance problems. If it is not possible to avoid these calls, there are several solutions to improve the performance. But not for all situations.
Performance Tips: PL/SQL Functions in SQL Queries
5