APPS.PSA_AR_GL_POST_PKG dependencies on ALL_OBJECTS

Line 28: FROM ALL_OBJECTS

24: -- to find the exact schema name
25: CURSOR c_fv_pkg_chk
26: IS
27: SELECT DISTINCT 'Y' fv_package
28: FROM ALL_OBJECTS
29: WHERE object_name = 'FV_AR_PKG'
30: AND object_type = 'PACKAGE'
31: AND owner = ( SELECT oracle_username
32: FROM fnd_oracle_userid