APPS.CN_COLLECTION_GEN dependencies on USER_OBJECTS

Line 1826: FROM user_objects

1822:
1823: CURSOR compile_pkg_cur IS
1824: SELECT object_name || ' ' ||
1825: decode(object_type, 'PACKAGE BODY','compile body','PACKAGE','compile') stmt
1826: FROM user_objects
1827: WHERE object_name LIKE 'CN_COLLECT%'
1828: AND substr(object_name, (INSTR(object_name,'_',1,3)+1), 1)IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
1829: AND object_type LIKE 'PACKAGE%'
1830: AND status = 'INVALID';

Line 1835: FROM user_objects

1831:
1832:
1833: CURSOR drop_pkg_cur IS
1834: SELECT object_name stmt
1835: FROM user_objects
1836: WHERE object_name LIKE 'CN_COLLECT%'
1837: AND substr(object_name, (INSTR(object_name,'_',1,3)+1), 1)IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
1838: AND object_type LIKE 'PACKAGE%'
1839: AND status = 'INVALID';