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 281: FROM WMS_RULES_B rl , all_objects obj

277: ORDER BY rule_weight DESC, creation_date;*/
278: -- modified by grao to exclude the invalid rules but status enabled
279: -- Fix for Bug 11907124. added leading hint /*+ leading(rl) */
280: SELECT /*+ leading(rl) */ rl.rule_id
281: FROM WMS_RULES_B rl , all_objects obj
282: WHERE rl.enabled_flag = 'Y'
283: AND rl.type_code = p_type_code
284: AND (obj.object_name = 'WMS_RULE_'|| to_char(rl.rule_id)
285: AND obj.object_type = 'PACKAGE BODY'