APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 4695: , po_requisition_lines_all prl

4691: -- Expense or parent Temp Labor line.
4692: CURSOR shipment_labor_expense_req_csr ( p_line_location_id NUMBER ) IS
4693: SELECT 'Backing Temp Labor/Expense Req'
4694: FROM po_distributions_all pod
4695: , po_requisition_lines_all prl
4696: , po_req_distributions_all prd
4697: WHERE pod.line_location_id = p_line_location_id -- For each PO Distribution
4698: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4699: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.

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

4698: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4699: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.
4700: AND ( ( prl.labor_req_line_id IS NOT NULL ) -- That Req Line must be an Expense line
4701: OR ( EXISTS ( SELECT 'Parent Temp Labor Req Line' -- or a parent Temp Labor line
4702: FROM po_requisition_lines_all prl2 -- of some Expense line.
4703: WHERE prl2.labor_req_line_id = prl.requisition_line_id
4704: )
4705: )
4706: );

Line 4712: , po_requisition_lines_all prl

4708: -- Expense or parent Temp Labor line.
4709: CURSOR line_labor_expense_req_csr ( p_po_line_id NUMBER ) IS
4710: SELECT 'Backing Temp Labor/Expense Req'
4711: FROM po_distributions_all pod
4712: , po_requisition_lines_all prl
4713: , po_req_distributions_all prd
4714: WHERE pod.po_line_id = p_po_line_id -- For each PO Distribution
4715: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4716: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.

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

4715: AND pod.req_distribution_id = prd.distribution_id -- join to backing Req Distribution
4716: AND prd.requisition_line_id = prl.requisition_line_id -- and then up to the Req Line.
4717: AND ( ( prl.labor_req_line_id IS NOT NULL ) -- That Req Line must be an Expense line
4718: OR ( EXISTS ( SELECT 'Parent Temp Labor Req Line' -- or a parent Temp Labor line
4719: FROM po_requisition_lines_all prl2 -- of some Expense line.
4720: WHERE prl2.labor_req_line_id = prl.requisition_line_id
4721: )
4722: )
4723: );