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: /* <> */

Line 382: EXISTS (select null from po_requisition_headers h

378: )
379: SELECT l_procedure_id
380: FROM DUAL
381: WHERE
382: EXISTS (select null from po_requisition_headers h
383: WHERE h.requisition_header_id = p_req_header_id(i)
384: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))
385: AND (p_req_line_id(i) IS NULL
386: OR EXISTS (SELECT null from po_requisition_lines l

Line 519: FROM po_requisition_headers h

515: -1, TYPE_LOOKUP_CODE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
516: SEGMENT1, SUMMARY_FLAG, ENABLED_FLAG,
517: NVL(authorization_status, 'INCOMPLETE'), nvl(closed_code, 'OPEN'),
518: NVL(cancel_flag, 'N'), l_sequence(i)
519: FROM po_requisition_headers h
520: WHERE h.requisition_header_id = p_req_header_id(i)
521: ;
522:
523: