DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on AP_TERMS

Line 6102: AND NOT EXISTS (select 'Y' from ap_terms where term_id = neg_header_record_data.payment_terms_id and SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE-1) AND NVL(END_DATE_ACTIVE,SYSDATE+1)))

6098: l_cp_user_id,
6099: SYSDATE,
6100: l_cp_login_id)
6101: WHEN(neg_header_record_data.payment_terms_id IS NOT NULL
6102: AND NOT EXISTS (select 'Y' from ap_terms where term_id = neg_header_record_data.payment_terms_id and SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE-1) AND NVL(END_DATE_ACTIVE,SYSDATE+1)))
6103: THEN INTO PON_INTERFACE_ERRORS
6104: (
6105: INTERFACE_TYPE ,
6106: ERROR_MESSAGE_NAME,