DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on ALL_OBJECTS

Line 6728: FROM ALL_OBJECTS

6724: -- Bug 3861686, added subquery to get the owner of the package.
6725:
6726: CURSOR c_fv_prepay_pkg is
6727: SELECT DISTINCT 'Y' status
6728: FROM ALL_OBJECTS
6729: WHERE object_name = 'FV_AP_PREPAY_PKG'
6730: AND object_type = 'PACKAGE'
6731: AND owner = (SELECT oracle_username
6732: FROM fnd_oracle_userid