APPS.PO_VAL_HEADERS2 dependencies on PO_HEADERS

Line 84: FROM po_headers_all poh

80: DECODE(p_po_header_id_tbl(i), NULL, PO_VAL_CONSTANTS.c_po_header_id_not_null,
81: PO_VAL_CONSTANTS.c_po_header_id_unique)
82: FROM DUAL
83: WHERE p_id_tbl(i) IS NULL OR EXISTS(SELECT 1
84: FROM po_headers_all poh
85: WHERE p_po_header_id_tbl(i) = poh.po_header_id);
86:
87: IF (SQL%ROWCOUNT > 0) THEN
88: x_result_type := po_validations.c_result_type_failure;

Line 167: FROM po_headers

163: PO_VAL_CONSTANTS.c_document_num_unique
164: FROM DUAL
165: WHERE p_document_num_tbl(i) IS NOT NULL AND
166: EXISTS(SELECT 1
167: FROM po_headers
168: WHERE segment1 = p_document_num_tbl(i)
169: AND ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
170: AND
171: type_lookup_code IN ('BLANKET', 'CONTRACT',