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

313:
314: select 'Y'
315: into l_error_occur
316: FROM
317: PO_REQUISITION_HEADERS PRH
318: WHERE PRH.requisition_header_id = l_document_id
319: AND NOT EXISTS (SELECT 'Lines Exist' FROM PO_REQUISITION_LINES
320: PRL WHERE PRL.requisition_header_id = PRH.requisition_header_id
321: AND nvl(PRL.cancel_flag,'N') = 'N');

Line 543: , PO_REQUISITION_HEADERS_ALL PRH

539: FROM
540: FINANCIALS_SYSTEM_PARAMETERS FSP
541: , PO_REQ_DISTRIBUTIONS PRD
542: , PO_REQUISITION_LINES PRL
543: , PO_REQUISITION_HEADERS_ALL PRH
544: WHERE PRD.requisition_line_id = PRL.requisition_line_id
545: AND PRL.requisition_header_id = PRH.requisition_header_id
546: AND PRL.requisition_header_id = l_document_id
547: AND PRL.line_location_id IS NULL