APPS.CN_FORMULA_GEN_PKG dependencies on USER_OBJECTS

Line 5256: from user_objects

5252:
5253: CURSOR compile_pkg_cur IS
5254: select object_name || ' ' ||
5255: decode(object_type, 'PACKAGE BODY','compile body','PACKAGE','compile') stmt
5256: from user_objects
5257: where object_name like 'CN_FORMULA%PKG'
5258: and substr(object_name, 12, 1)in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
5259: and object_type like 'PACKAGE%'
5260: and status = 'INVALID';

Line 5264: from user_objects

5260: and status = 'INVALID';
5261:
5262: CURSOR drop_pkg_cur IS
5263: select object_name stmt
5264: from user_objects
5265: where object_name like 'CN_FORMULA%PKG'
5266: and substr(object_name, 12, 1)in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
5267: and object_type like 'PACKAGE%'
5268: and status = 'INVALID';