DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on ALL_OBJECTS

Line 6653: FROM ALL_OBJECTS

6649: -- Bug 3861686, added subquery to get the owner of the package.
6650:
6651: CURSOR c_fv_prepay_pkg is
6652: SELECT DISTINCT 'Y' status
6653: FROM ALL_OBJECTS
6654: WHERE object_name = 'FV_AP_PREPAY_PKG'
6655: AND object_type = 'PACKAGE'
6656: AND owner = (SELECT oracle_username
6657: FROM fnd_oracle_userid