APPS.PO_VALIDATION_HELPER dependencies on AP_TERMS

Line 2439: -- Validates the terms_id agains ap_terms

2435: --Pre-reqs: None.
2436: --Modifies: PO_VALIDATION_RESULTS_GT
2437: --Locks: None.
2438: --Function:
2439: -- Validates the terms_id agains ap_terms
2440: -- and adds an error to the results table if it's invalid.
2441: --Parameters:
2442: --IN:
2443: --p_calling_module

Line 2510: FROM AP_TERMS APT

2506: FROM DUAL
2507: WHERE p_terms_id_tbl(i) IS NOT NULL
2508: AND NOT EXISTS
2509: (SELECT 1
2510: FROM AP_TERMS APT
2511: WHERE p_terms_id_tbl(i) = APT.TERM_ID
2512: AND sysdate BETWEEN
2513: nvl(APT.start_date_active, sysdate - 1) AND
2514: nvl(APT.end_date_active, sysdate + 1)); -- END WHERE, FORALL