APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 3167: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;

3163: l_action VARCHAR2(30);
3164: l_doc_id_tbl po_tbl_number;
3165: --
3166: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3167: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3168: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3169: l_return_status VARCHAR2(1);
3170: --Bug 11665915 Custom hook to validate funds in an external financial system - variables
3171:

Line 3359: FROM po_requisition_headers_all

3355: l_req_document_id := p_doc_level_id;
3356:
3357: SELECT Nvl(par_flag,'N')
3358: INTO l_is_par_dummy_req
3359: FROM po_requisition_headers_all
3360: WHERE REQUISITION_HEADER_ID = l_req_document_id;
3361:
3362: ELSIF p_doc_level='LINE' THEN
3363: SELECT requisition_header_id into l_req_document_id

Line 3370: FROM po_requisition_headers_all

3366:
3367:
3368: SELECT Nvl(par_flag,'N')
3369: INTO l_is_par_dummy_req
3370: FROM po_requisition_headers_all
3371: WHERE REQUISITION_HEADER_ID = l_req_document_id;
3372:
3373: ELSIF p_doc_level='DISTRIBUTION' THEN
3374: SELECT requisition_header_id into l_req_document_id

Line 3382: FROM po_requisition_headers_all

3378:
3379:
3380: SELECT Nvl(par_flag,'N')
3381: INTO l_is_par_dummy_req
3382: FROM po_requisition_headers_all
3383: WHERE REQUISITION_HEADER_ID = l_req_document_id;
3384:
3385: END IF;
3386: END IF;

Line 4487: -- PO_REQUISITION_HEADERS_ALL

4483: --Locks:
4484: -- PO_HEADERS_ALL
4485: -- PO_RELEASES_ALL
4486: -- PO_DISTRIBUTIONS_ALL
4487: -- PO_REQUISITION_HEADERS_ALL
4488: -- PO_REQ_DISTRIBUTIONS_ALL
4489: --Function:
4490: -- Flattens the PO transaction tables to retrieve all of the
4491: -- data needed by the encumbrance code and put it in the

Line 4743: , PO_REQUISITION_HEADERS_ALL PRH

4739: /* <> */
4740: FROM
4741: PO_REQ_DISTRIBUTIONS_ALL PRD
4742: , PO_REQUISITION_LINES_ALL PRL
4743: , PO_REQUISITION_HEADERS_ALL PRH
4744: , PO_SESSION_GT DIST_IDS
4745: WHERE PRH.requisition_header_id = PRL.requisition_header_id --JOIN
4746: AND PRL.requisition_line_id = PRD.requisition_line_id --JOIN
4747: AND PRD.distribution_id = DIST_IDS.num1 --JOIN