APPS.PO_POAPPROVAL_INIT1 dependencies on PO_LINES

Line 1487: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

1483: -- employee_id of the requester
1484: --End of Comments
1485: -------------------------------------------------------------------------------
1486: PROCEDURE get_temp_labor_requester (
1487: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
1488: x_requester_id OUT NOCOPY PO_REQUISITION_LINES.to_person_id%TYPE
1489: ) IS
1490: l_proc_name CONSTANT VARCHAR2(30) := 'get_temp_labor_requester';
1491: l_progress VARCHAR2(3) := '000';

Line 1494: p_po_line_id PO_LINES.po_line_id%TYPE

1490: l_proc_name CONSTANT VARCHAR2(30) := 'get_temp_labor_requester';
1491: l_progress VARCHAR2(3) := '000';
1492:
1493: CURSOR l_line_req_requester_csr (
1494: p_po_line_id PO_LINES.po_line_id%TYPE
1495: ) IS
1496: -- SQL What: Retrieves the requester from the backing requisition of the
1497: -- PO line, if available.
1498: -- SQL Why: To determine the recipient of the Temp Labor notification.

Line 1508: FROM po_lines POL,

1504: -- Bug 5004284: Restored the outer join that was removed in 120.4. This
1505: -- is necessary because even if no backing requisition lines were found,
1506: -- we still want to return POH.agent_id.
1507: SELECT PRL.to_person_id, POH.agent_id
1508: FROM po_lines POL,
1509: po_line_locations PLL,
1510: -- For Shared Procurement, the destination OU may be different from
1511: -- the Purchasing OU:
1512: po_requisition_lines_all PRL,

Line 1521: p_po_line_id PO_LINES.po_line_id%TYPE

1517: AND POH.po_header_id = POL.po_header_id -- JOIN
1518: ORDER BY PLL.shipment_num;
1519:
1520: CURSOR l_line_dist_requesters_csr (
1521: p_po_line_id PO_LINES.po_line_id%TYPE
1522: ) IS
1523: -- SQL What: For the given PO line, retrieves the requesters from the
1524: -- distributions, starting with the first distribution that has a
1525: -- requester.

Line 1671: po_lines POL,

1667: POL.contractor_first_name,
1668: POL.contractor_last_name,
1669: PJ.name job_name
1670: FROM po_headers POH,
1671: po_lines POL,
1672: per_jobs_vl PJ
1673: WHERE POH.po_header_id = p_po_header_id
1674: AND POH.po_header_id = POL.po_header_id -- JOIN
1675: AND POL.purchase_basis = 'TEMP LABOR'

Line 1684: FROM po_lines_archive PLA

1680: -- For an existing document, we only want the new lines - i.e.
1681: -- the lines that do not have any older archived revisions.
1682: NOT EXISTS
1683: (SELECT 1
1684: FROM po_lines_archive PLA
1685: WHERE PLA.po_line_id = POL.po_line_id -- JOIN
1686: AND PLA.revision_num <> POH.revision_num));
1687:
1688: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;

Line 1926: FROM po_lines POL,

1922: PRL.requisition_header_id
1923: INTO l_po_header_id,
1924: l_document_number,
1925: l_req_header_id
1926: FROM po_lines POL,
1927: po_headers POH,
1928: po_line_locations PLL,
1929: po_requisition_lines_all PRL
1930: WHERE POL.po_line_id = p_po_line_id