APPS.PA_PROJ_TSK_UTILS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 394: FROM po_req_distributions_all

390: cursor c1 is
391: SELECT 1
392: FROM sys.dual
393: WHERE EXISTS (SELECT NULL
394: FROM po_req_distributions_all
395: WHERE project_id = x_project_id
396: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag
397:
398: cursor c2 is

Line 402: FROM po_req_distributions_all

398: cursor c2 is
399: SELECT 1
400: FROM sys.dual
401: where exists (SELECT NULL
402: FROM po_req_distributions_all
403: where project_id = x_proj_id
404: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag
405: AND TASK_ID IN
406: (SELECT TASK_ID

Line 415: FROM po_req_distributions_all

411: /* cursor c2 is
412: SELECT 1
413: FROM sys.dual
414: where exists (SELECT NULL
415: FROM po_req_distributions_all
416: where project_id = x_proj_id
417: AND TASK_ID IN
418: (SELECT TASK_ID
419: FROM PA_TASKS

Line 430: FROM po_req_distributions_all

426: cursor c3 is
427: SELECT 1
428: FROM sys.dual
429: where exists (SELECT NULL
430: FROM po_req_distributions_all
431: where project_id = x_proj_id
432: AND TASK_ID = x_TASK_ID);
433: c3_rec c3%rowtype;
434: begin