APPS.PO_APPROVAL_ACTION dependencies on PO_REQUISITION_HEADERS

Line 41: from PO_REQUISITION_HEADERS PRH

37:
38:
39: select nvl(PRH.authorization_status,'INCOMPLETE')
40: into l_authorization_status
41: from PO_REQUISITION_HEADERS PRH
42: where PRH.requisition_header_id = l_document_id;
43:
44: if ( not (l_authorization_status = 'INCOMPLETE' or
45: l_authorization_status = 'IN PROCESS' or

Line 59: FROM po_requisition_headers prh,

55: -- at most the no row check
56: begin
57: SELECT 'Y'
58: into l_code_exist
59: FROM po_requisition_headers prh,
60: po_lookup_codes plc_clo
61: WHERE plc_clo.lookup_code = nvl(prh.closed_code, 'OPEN')
62: AND plc_clo.lookup_type = 'DOCUMENT STATE'
63: AND prh.requisition_header_id = l_document_id;

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 351: PO_REQUISITION_HEADERS PRH

347:
348: select 'Y'
349: into l_error_occur
350: FROM
351: PO_REQUISITION_HEADERS PRH
352: WHERE PRH.requisition_header_id = l_document_id
353: AND NOT EXISTS (SELECT 'Lines Exist' FROM po_requisition_lines_clm_v
354: PRL WHERE PRL.requisition_header_id = PRH.requisition_header_id
355: AND nvl(PRL.cancel_flag,'N') = '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