DBA Data[Home] [Help]

APPS.PJM_PROJTASK_DELETION dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 133: FROM po_req_distributions_all rdist

129: FROM dual
130: WHERE
131: EXISTS (
132: SELECT 1
133: FROM po_req_distributions_all rdist
134: WHERE rdist.project_id = l_project_id
135: AND rdist.task_id = NVL(p_task_id, rdist.task_id)
136: );
137:

Line 387: FROM po_req_distributions_all rdist

383: AND dist.destination_organization_id = p_org_id
384: ) OR
385: EXISTS (
386: SELECT 1
387: FROM po_req_distributions_all rdist
388: , po_requisition_lines_all rline
389: WHERE rdist.project_id = p_project_id
390: AND rline.requisition_line_id = rdist.requisition_line_id
391: AND rline.destination_organization_id = p_org_id