APPS.PO_VALIDATION_HELPER dependencies on AP_TERMS

Line 2254: -- Validates the terms_id agains ap_terms

2250: --Pre-reqs: None.
2251: --Modifies: PO_VALIDATION_RESULTS_GT
2252: --Locks: None.
2253: --Function:
2254: -- Validates the terms_id agains ap_terms
2255: -- and adds an error to the results table if it's invalid.
2256: --Parameters:
2257: --IN:
2258: --p_calling_module

Line 2325: FROM AP_TERMS APT

2321: FROM DUAL
2322: WHERE p_terms_id_tbl(i) IS NOT NULL
2323: AND NOT EXISTS
2324: (SELECT 1
2325: FROM AP_TERMS APT
2326: WHERE p_terms_id_tbl(i) = APT.TERM_ID
2327: AND sysdate BETWEEN
2328: nvl(APT.start_date_active, sysdate - 1) AND
2329: nvl(APT.end_date_active, sysdate + 1)); -- END WHERE, FORALL