APPS.PO_POAPPROVAL_INIT1 dependencies on PO_RELEASES_ALL

Line 33: from po_releases_all PORL, po_headers_all POH

29: Cursor GetRelHdr_csr(p_rel_header_id NUMBER) RETURN RelHdrRecord is
30: select PORL.PO_RELEASE_ID,PORL.PO_HEADER_ID,PORL.AUTHORIZATION_STATUS,
31: PORL.RELEASE_TYPE,PORL.AGENT_ID,PORL.RELEASE_NUM,PORL.CLOSED_CODE,
32: POH.SEGMENT1, POH.CURRENCY_CODE
33: from po_releases_all PORL, po_headers_all POH
34: where PORL.PO_RELEASE_ID = p_rel_header_id
35: and PORL.po_header_id = POH.po_header_id;
36:
37: -- The following are local/Private procedure that support the workflow APIs:

Line 1789: FROM po_releases_all

1785:
1786: IF (p_doc_type = 'RELEASE') THEN
1787: SELECT approved_date
1788: INTO x_approved_date
1789: FROM po_releases_all
1790: WHERE po_release_id = p_doc_id;
1791: ELSE
1792: SELECT approved_date
1793: INTO x_approved_date