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 850: from PO_RELEASES_ALL

846: SELECT RELEASE_TYPE,
847: org_id -- Bug 3362534
848: INTO l_doc_subtype,
849: l_document_org_id
850: from PO_RELEASES_ALL
851: WHERE po_release_id = p_po_release_id(i);
852: l_doc_type := 'RELEASE';
853: ELSE
854: SELECT TYPE_LOOKUP_CODE,

Line 1098: FROM po_releases_all

1094: -- Retrieve the document's operating unit.
1095: IF p_chg.po_release_id IS NOT NULL THEN
1096: SELECT org_id, authorization_status
1097: INTO l_document_org_id, l_authorization_status
1098: FROM po_releases_all
1099: WHERE po_release_id = p_chg.po_release_id;
1100: ELSE -- PO
1101: SELECT org_id, authorization_status
1102: INTO l_document_org_id, l_authorization_status