APPS.PA_PROJ_TSK_UTILS dependencies on PO_DISTRIBUTIONS_ALL

Line 270: FROM po_distributions_all

266: cursor c1 is
267: SELECT 1
268: FROM sys.dual
269: WHERE EXISTS (SELECT NULL
270: FROM po_distributions_all
271: WHERE project_id = x_project_id
272: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag
273:
274: cursor c2 is

Line 278: FROM po_distributions_all

274: cursor c2 is
275: SELECT 1
276: FROM sys.dual
277: where exists (SELECT NULL
278: FROM po_distributions_all
279: where project_id = x_proj_id
280: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag
281: AND TASK_ID IN
282: (SELECT TASK_ID

Line 291: FROM po_distributions_all

287: /* cursor c2 is
288: SELECT 1
289: FROM sys.dual
290: where exists (SELECT NULL
291: FROM po_distributions_all
292: where project_id = x_proj_id
293: AND TASK_ID IN
294: (SELECT TASK_ID
295: FROM PA_TASKS

Line 306: FROM po_distributions_all

302: cursor c3 is
303: SELECT 1
304: FROM sys.dual
305: where exists (SELECT NULL
306: FROM po_distributions_all
307: where project_id = x_proj_id
308: AND TASK_ID = x_TASK_ID);
309: c3_rec c3%rowtype;
310: begin