APPS.HZ_BES_BO_GEN_PKG dependencies on ALL_PLSQL_OBJECT_SETTINGS

Line 319: FROM ALL_PLSQL_OBJECT_SETTINGS

315: -- get the schema name that owns the pkg bdy
316:
317: SELECT 1
318: INTO l_tmp
319: FROM ALL_PLSQL_OBJECT_SETTINGS
320: WHERE NAME = 'HZ_BES_BO_SITE_UTIL_PKG'
321: AND TYPE = 'PACKAGE BODY' AND OWNER = l_schema_name ;
322:
323: IF l_tmp = 1 THEN