APPS.WMS_RULE_GEN_PKGS dependencies on ALL_OBJECTS

Line 123: FROM all_objects

119: SELECT 1
120: FROM dual
121: WHERE exists(
122: SELECT status
123: FROM all_objects
124: WHERE object_name = p_package_name
125: AND object_type = 'PACKAGE'
126: AND status <> 'VALID'
127: AND owner = g_owner);

Line 134: FROM all_objects

130: SELECT 1
131: FROM dual
132: WHERE exists(
133: SELECT status
134: FROM all_objects
135: WHERE object_name = p_package_name
136: AND object_type = 'PACKAGE BODY'
137: AND status <> 'VALID'
138: AND owner = g_owner);

Line 274: FROM WMS_RULES_B rl , all_objects obj

270: AND type_code = p_type_code
271: ORDER BY rule_weight DESC, creation_date;*/
272: -- modified by grao to exclude the invalid rules but status enabled
273: SELECT rl.rule_id
274: FROM WMS_RULES_B rl , all_objects obj
275: WHERE rl.enabled_flag = 'Y'
276: AND rl.type_code = p_type_code
277: AND (obj.object_name = 'WMS_RULE_'|| to_char(rl.rule_id)
278: AND obj.object_type = 'PACKAGE BODY'