APPS.PO_POAPPROVAL_INIT1 dependencies on PO_LINES

Line 1255: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

1251: -- employee_id of the requester
1252: --End of Comments
1253: -------------------------------------------------------------------------------
1254: PROCEDURE get_temp_labor_requester (
1255: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1256: x_requester_id OUT NOCOPY PO_REQUISITION_LINES.to_person_id%TYPE
1257: ) IS
1258: l_proc_name CONSTANT VARCHAR2(30) := 'get_temp_labor_requester';
1259: l_progress VARCHAR2(3) := '000';

Line 1262: p_po_line_id PO_LINES.po_line_id%TYPE

1258: l_proc_name CONSTANT VARCHAR2(30) := 'get_temp_labor_requester';
1259: l_progress VARCHAR2(3) := '000';
1260:
1261: CURSOR l_line_req_requester_csr (
1262: p_po_line_id PO_LINES.po_line_id%TYPE
1263: ) IS
1264: -- SQL What: Retrieves the requester from the backing requisition of the
1265: -- PO line, if available.
1266: -- SQL Why: To determine the recipient of the Temp Labor notification.

Line 1276: FROM po_lines POL,

1272: -- Bug 5004284: Restored the outer join that was removed in 120.4. This
1273: -- is necessary because even if no backing requisition lines were found,
1274: -- we still want to return POH.agent_id.
1275: SELECT PRL.to_person_id, POH.agent_id
1276: FROM po_lines POL,
1277: po_line_locations PLL,
1278: -- For Shared Procurement, the destination OU may be different from
1279: -- the Purchasing OU:
1280: po_requisition_lines_all PRL,

Line 1289: p_po_line_id PO_LINES.po_line_id%TYPE

1285: AND POH.po_header_id = POL.po_header_id -- JOIN
1286: ORDER BY PLL.shipment_num;
1287:
1288: CURSOR l_line_dist_requesters_csr (
1289: p_po_line_id PO_LINES.po_line_id%TYPE
1290: ) IS
1291: -- SQL What: For the given PO line, retrieves the requesters from the
1292: -- distributions, starting with the first distribution that has a
1293: -- requester.

Line 1439: po_lines POL,

1435: POL.contractor_first_name,
1436: POL.contractor_last_name,
1437: PJ.name job_name
1438: FROM po_headers POH,
1439: po_lines POL,
1440: per_jobs_vl PJ
1441: WHERE POH.po_header_id = p_po_header_id
1442: AND POH.po_header_id = POL.po_header_id -- JOIN
1443: AND POL.purchase_basis = 'TEMP LABOR'

Line 1452: FROM po_lines_archive PLA

1448: -- For an existing document, we only want the new lines - i.e.
1449: -- the lines that do not have any older archived revisions.
1450: NOT EXISTS
1451: (SELECT 1
1452: FROM po_lines_archive PLA
1453: WHERE PLA.po_line_id = POL.po_line_id -- JOIN
1454: AND PLA.revision_num <> POH.revision_num));
1455:
1456: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;

Line 1675: FROM po_lines POL,

1671: PRL.requisition_header_id
1672: INTO l_po_header_id,
1673: l_document_number,
1674: l_req_header_id
1675: FROM po_lines POL,
1676: po_headers POH,
1677: po_line_locations PLL,
1678: po_requisition_lines_all PRL
1679: WHERE POL.po_line_id = p_po_line_id