APPS.CN_COLLECTION_GEN dependencies on USER_OBJECTS

Line 1891: FROM user_objects

1887:
1888: CURSOR compile_pkg_cur IS
1889: SELECT object_name || ' ' ||
1890: decode(object_type, 'PACKAGE BODY','compile body','PACKAGE','compile') stmt
1891: FROM user_objects
1892: WHERE object_name LIKE 'CN_COLLECT%'
1893: AND substr(object_name, (INSTR(object_name,'_',1,3)+1), 1)IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
1894: AND object_type LIKE 'PACKAGE%'
1895: AND status = 'INVALID';

Line 1900: FROM user_objects

1896:
1897:
1898: CURSOR drop_pkg_cur IS
1899: SELECT object_name stmt
1900: FROM user_objects
1901: WHERE object_name LIKE 'CN_COLLECT%'
1902: AND substr(object_name, (INSTR(object_name,'_',1,3)+1), 1)IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
1903: AND object_type LIKE 'PACKAGE%'
1904: AND status = 'INVALID';