APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 4870: , po_requisition_lines_all prl

4866: -- Expense or parent Temp Labor line.
4867: CURSOR shipment_labor_expense_req_csr ( p_line_location_id NUMBER ) IS
4868: SELECT 'Backing Temp Labor/Expense Req'
4869: FROM po_distributions_all pod
4870: , po_requisition_lines_all prl
4871: , po_req_distributions_all prd
4872: WHERE pod.line_location_id = p_line_location_id -- For each PO Distribution
4873: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4874: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.

Line 4877: FROM po_requisition_lines_all prl2 -- of some Expense line.

4873: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4874: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.
4875: AND ( ( prl.labor_req_line_id IS NOT NULL ) -- That Req Line must be an Expense line
4876: OR ( EXISTS ( SELECT 'Parent Temp Labor Req Line' -- or a parent Temp Labor line
4877: FROM po_requisition_lines_all prl2 -- of some Expense line.
4878: WHERE prl2.labor_req_line_id = prl.requisition_line_id
4879: )
4880: )
4881: );

Line 4887: , po_requisition_lines_all prl

4883: -- Expense or parent Temp Labor line.
4884: CURSOR line_labor_expense_req_csr ( p_po_line_id NUMBER ) IS
4885: SELECT 'Backing Temp Labor/Expense Req'
4886: FROM po_distributions_all pod
4887: , po_requisition_lines_all prl
4888: , po_req_distributions_all prd
4889: WHERE pod.po_line_id = p_po_line_id -- For each PO Distribution
4890: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4891: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.

Line 4894: FROM po_requisition_lines_all prl2 -- of some Expense line.

4890: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4891: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.
4892: AND ( ( prl.labor_req_line_id IS NOT NULL ) -- That Req Line must be an Expense line
4893: OR ( EXISTS ( SELECT 'Parent Temp Labor Req Line' -- or a parent Temp Labor line
4894: FROM po_requisition_lines_all prl2 -- of some Expense line.
4895: WHERE prl2.labor_req_line_id = prl.requisition_line_id
4896: )
4897: )
4898: );