APPS.CN_FORMULA_GEN_PKG dependencies on USER_OBJECTS

Line 5336: FROM user_objects

5332: l_form_list cn_form_tab;
5333:
5334: CURSOR pkg_cur IS
5335: SELECT object_name stmt
5336: FROM user_objects
5337: WHERE object_name LIKE 'CN_FORMULA%PKG'
5338: AND SUBSTR(object_name, 12, 1)in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
5339: AND object_type = 'PACKAGE';
5340:

Line 5349: from user_objects

5345:
5346: CURSOR compile_pkg_cur IS
5347: select object_name || ' ' ||
5348: decode(object_type, 'PACKAGE BODY','compile body','PACKAGE','compile') stmt
5349: from user_objects
5350: where object_name like 'CN_FORMULA%PKG'
5351: and substr(object_name, 12, 1)in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
5352: and object_type like 'PACKAGE%'
5353: and status = 'INVALID';

Line 5357: from user_objects

5353: and status = 'INVALID';
5354:
5355: CURSOR drop_pkg_cur IS
5356: select object_name stmt
5357: from user_objects
5358: where object_name like 'CN_FORMULA%PKG'
5359: and substr(object_name, 12, 1)in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
5360: and object_type like 'PACKAGE%'
5361: and status = 'INVALID';