DBA Data[Home] [Help]

APPS.PO_APPROVAL_ACTION dependencies on PO_REQUISITION_HEADERS_ALL

Line 305: FROM po_requisition_headers_all

301: x_progress := 'req_complete_check 003' || to_char(l_document_id);
302:
303: BEGIN
304: SELECT federal_flag INTO l_federal_flag
305: FROM po_requisition_headers_all
306: WHERE requisition_header_id = l_document_id;
307:
308: IF l_federal_flag IS NULL THEN
309: l_federal_flag := 'N';

Line 585: , PO_REQUISITION_HEADERS_ALL PRH

581: FROM
582: FINANCIALS_SYSTEM_PARAMETERS FSP
583: , PO_REQ_DISTRIBUTIONS PRD
584: , po_requisition_lines_clm_v PRL
585: , PO_REQUISITION_HEADERS_ALL PRH
586: WHERE PRD.requisition_line_id = PRL.requisition_line_id
587: AND PRL.requisition_header_id = PRH.requisition_header_id
588: AND PRL.requisition_header_id = l_document_id
589: AND PRL.line_location_id IS NULL