DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_TERMS

Line 971: FROM ap_terms apt, ap_terms_lines atl

967: BEGIN
968: --these are not multi-org table so should be fine
969: SELECT apt.term_id
970: INTO l_interest_terms_id
971: FROM ap_terms apt, ap_terms_lines atl
972: WHERE apt.term_id = atl.term_id
973: AND atl.due_days=0
974: AND nvl(end_date_active,sysdate+1) >= sysdate
975: AND rownum < 2;