APPS.PO_OM_INTEGRATION_GRP dependencies on PO_RELEASES_ALL

Line 129: l_cur_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;

125: l_processed_releases INDEXED_TBL_NUMBER;
126: l_processed_reqs INDEXED_TBL_NUMBER;
127:
128: l_cur_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
129: l_cur_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;
130: l_cur_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
131: l_start_index NUMBER;
132:
133: l_po_changes PO_CHANGES_REC_TYPE;

Line 724: from PO_RELEASES_ALL

720: SELECT RELEASE_TYPE,
721: org_id -- Bug 3362534
722: INTO l_doc_subtype,
723: l_document_org_id
724: from PO_RELEASES_ALL
725: WHERE po_release_id = p_po_release_id(i);
726: l_doc_type := 'RELEASE';
727: ELSE
728: SELECT TYPE_LOOKUP_CODE,

Line 972: FROM po_releases_all

968: -- Retrieve the document's operating unit.
969: IF p_chg.po_release_id IS NOT NULL THEN
970: SELECT org_id, authorization_status
971: INTO l_document_org_id, l_authorization_status
972: FROM po_releases_all
973: WHERE po_release_id = p_chg.po_release_id;
974: ELSE -- PO
975: SELECT org_id, authorization_status
976: INTO l_document_org_id, l_authorization_status