APPS.PJM_PROJTASK_DELETION dependencies on DUAL

Line 46: FROM dual

42: l_not_found BOOLEAN;
43:
44: CURSOR c1 IS
45: SELECT 1
46: FROM dual
47: WHERE
48: EXISTS (
49: SELECT 1
50: FROM pjm_project_parameters ppp

Line 59: FROM dual

55: AND p_task_id is null
56: );
57: CURSOR c2 IS
58: SELECT 1
59: FROM dual
60: WHERE
61: EXISTS (
62: SELECT 1
63: FROM oe_order_lines_all ool

Line 69: FROM dual

65: AND ool.task_id = NVL(p_task_id, ool.task_id)
66: );
67: CURSOR c3 IS
68: SELECT 1
69: FROM dual
70: WHERE
71: EXISTS (
72: SELECT 1
73: FROM wip_discrete_jobs job

Line 79: FROM dual

75: AND job.task_id = NVL(p_task_id, job.task_id)
76: );
77: CURSOR c4 IS
78: SELECT 1
79: FROM dual
80: WHERE
81: EXISTS (
82: SELECT 1
83: FROM mtl_item_locations loc

Line 89: FROM dual

85: AND loc.task_id = NVL(p_task_id, loc.task_id)
86: );
87: CURSOR c5 IS
88: SELECT 1
89: FROM dual
90: WHERE
91: EXISTS (
92: SELECT 1
93: FROM mtl_material_transactions mmt

Line 99: FROM dual

95: AND mmt.source_task_Id = NVL(p_task_id, mmt.source_task_id)
96: ) );
97: CURSOR c6 IS
98: SELECT 1
99: FROM dual
100: WHERE
101: EXISTS (
102: SELECT 1
103: FROM mrp_forecast_dates frct

Line 109: FROM dual

105: AND frct.task_id = NVL(p_task_id, frct.task_id)
106: );
107: CURSOR c7 IS
108: SELECT 1
109: FROM dual
110: WHERE
111: EXISTS (
112: SELECT 1
113: FROM mrp_schedule_dates schd

Line 119: FROM dual

115: AND schd.task_id = NVL(p_task_id, schd.task_id)
116: );
117: CURSOR c8 IS
118: SELECT 1
119: FROM dual
120: WHERE
121: EXISTS (
122: SELECT 1
123: FROM po_distributions_all dist

Line 129: FROM dual

125: AND dist.task_id = NVL(p_task_id, dist.task_id)
126: );
127: CURSOR c9 IS
128: SELECT 1
129: FROM dual
130: WHERE
131: EXISTS (
132: SELECT 1
133: FROM po_req_distributions_all rdist

Line 140: FROM dual

136: );
137:
138: CURSOR c10 IS
139: SELECT 1
140: FROM dual
141: WHERE
142: EXISTS (
143: SELECT 1
144: FROM wip_transactions wip

Line 151: FROM dual

147: );
148:
149: CURSOR c11 IS
150: SELECT 1
151: FROM dual
152: WHERE
153: EXISTS (
154: SELECT 1
155: FROM mtl_material_transactions mmt

Line 162: FROM dual

158: ));
159:
160: CURSOR c12 IS
161: SELECT 1
162: FROM dual
163: WHERE
164: EXISTS (
165: SELECT 1
166: FROM mtl_material_transactions mmt

Line 281: FROM dual

277:
278: IF l_not_found THEN
279: SELECT 2
280: INTO l_dummy
281: FROM dual
282: WHERE EXISTS (
283: SELECT 1
284: FROM pjm_default_tasks pjm
285: WHERE pjm.project_id = l_project_id

Line 334: FROM dual

330: IF (p_org_id IS NOT NULL) AND (p_project_id IS NOT NULL) THEN
331:
332: SELECT 1
333: INTO retcode
334: FROM dual
335: WHERE
336: EXISTS (
337: SELECT 1
338: FROM oe_order_lines_all ool