APPS.PJM_PROJTASK_DELETION dependencies on PO_DISTRIBUTIONS_ALL

Line 123: FROM po_distributions_all dist

119: FROM dual
120: WHERE
121: EXISTS (
122: SELECT 1
123: FROM po_distributions_all dist
124: WHERE dist.project_id = l_project_id
125: AND dist.task_id = NVL(p_task_id, dist.task_id)
126: );
127: CURSOR c9 IS

Line 381: FROM po_distributions_all dist

377: AND schd.organization_id = p_org_id
378: ) OR
379: EXISTS (
380: SELECT 1
381: FROM po_distributions_all dist
382: WHERE dist.project_id = p_project_id
383: AND dist.destination_organization_id = p_org_id
384: ) OR
385: EXISTS (