APPS.EGO_LIFECYCLE_ADMIN_PUB dependencies on DUAL

Line 39: FROM DUAL

35: --Check if there are any entries for it in MTL_SYSTEM_ITEMS
36: BEGIN
37: SELECT 1
38: INTO l_count
39: FROM DUAL
40: WHERE EXISTS
41: (SELECT 'X'
42: FROM MTL_SYSTEM_ITEMS_B
43: WHERE LIFECYCLE_ID = p_lifecycle_id);

Line 57: FROM DUAL

53: IF (l_message IS NULL) THEN
54: BEGIN
55: SELECT 1
56: INTO l_count
57: FROM DUAL
58: WHERE EXISTS
59: (SELECT 'X'
60: FROM MTL_ITEM_REVISIONS_B
61: WHERE LIFECYCLE_ID = p_lifecycle_id);

Line 76: FROM DUAL

72: IF (l_message IS NULL) THEN
73: BEGIN
74: SELECT 1
75: INTO l_count
76: FROM DUAL
77: WHERE EXISTS
78: (SELECT 'X'
79: FROM MTL_PENDING_ITEM_STATUS
80: WHERE LIFECYCLE_ID = p_lifecycle_id);

Line 136: FROM DUAL

132:
133: BEGIN
134: SELECT 1
135: INTO l_count
136: FROM DUAL
137: WHERE EXISTS
138: (SELECT 'X'
139: FROM MTL_SYSTEM_ITEMS_B
140: WHERE CURRENT_PHASE_ID = p_phase_id);

Line 154: FROM DUAL

150: IF (l_message IS NULL) THEN
151: BEGIN
152: SELECT 1
153: INTO l_count
154: FROM DUAL
155: WHERE EXISTS
156: (SELECT 'X'
157: FROM MTL_ITEM_REVISIONS_B
158: WHERE CURRENT_PHASE_ID = p_phase_id);

Line 173: FROM DUAL

169: IF (l_message IS NULL) THEN
170: BEGIN
171: SELECT 1
172: INTO l_count
173: FROM DUAL
174: WHERE EXISTS
175: (SELECT 'X'
176: FROM MTL_PENDING_ITEM_STATUS
177: WHERE PHASE_ID = p_phase_id);