APPS.PO_REQ_DOCUMENT_CHECKS_PVT dependencies on PO_REQUISITION_HEADERS

Line 95: EXISTS (select null from po_requisition_headers h

91: )
92: SELECT l_procedure_id
93: FROM DUAL
94: WHERE
95: EXISTS (select null from po_requisition_headers h
96: WHERE h.requisition_header_id = p_req_header_id(i)
97: AND (h.authorization_status is NULL
98: OR h.authorization_status NOT IN ('PRE-APPROVED', 'IN PROCESS'))
99: AND (h.cancel_flag is null or h.cancel_flag <> 'Y')

Line 245: EXISTS (select null from po_requisition_headers h

241: )
242: SELECT l_procedure_id
243: FROM DUAL
244: WHERE
245: EXISTS (select null from po_requisition_headers h
246: WHERE h.requisition_header_id = p_req_header_id(i)
247: AND (h.authorization_status is NULL
248: OR h.authorization_status NOT IN ('APPROVED'))
249: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))

Line 377: EXISTS (select null from po_requisition_headers h

373: )
374: SELECT l_procedure_id
375: FROM DUAL
376: WHERE
377: EXISTS (select null from po_requisition_headers h
378: WHERE h.requisition_header_id = p_req_header_id(i)
379: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))
380: AND (p_req_line_id(i) IS NULL
381: OR EXISTS (SELECT null from po_requisition_lines l

Line 514: FROM po_requisition_headers h

510: -1, TYPE_LOOKUP_CODE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
511: SEGMENT1, SUMMARY_FLAG, ENABLED_FLAG,
512: NVL(authorization_status, 'INCOMPLETE'), nvl(closed_code, 'OPEN'),
513: NVL(cancel_flag, 'N'), l_sequence(i)
514: FROM po_requisition_headers h
515: WHERE h.requisition_header_id = p_req_header_id(i)
516: ;
517:
518: