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_interface

163: PO_VAL_CONSTANTS.c_document_num_unique
164: FROM DUAL
165: WHERE p_document_num_tbl(i) IS NOT NULL AND --8688769 bug
166: ( EXISTS (SELECT 1
167: FROM po_headers_interface
168: WHERE document_num =p_document_num_tbl(i)
169: AND Nvl(process_code,PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
170: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
171: GROUP BY document_num,org_id HAVING Count(document_num)>1) --14641487 bug

Line 174: FROM po_headers

170: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
171: GROUP BY document_num,org_id HAVING Count(document_num)>1) --14641487 bug
172: OR
173: EXISTS(SELECT 1
174: FROM po_headers
175: WHERE segment1 = p_document_num_tbl(i)
176: AND ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
177: AND
178: type_lookup_code IN ('BLANKET', 'CONTRACT',