DBA Data[Home] [Help]

APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INTEREST_PERIODS

Line 2412: FROM ap_payment_schedules, ap_interest_periods

2408: -due_date), 30)))) -
2409: NVL(P_amount_remaining - least(nvl(P_discount_taken, 0),
2410: P_discount_available), 0)
2411: INTO C_interest_amount
2412: FROM ap_payment_schedules, ap_interest_periods
2413: WHERE P_sys_auto_calc_int_flag = 'Y'
2414: AND P_auto_calculate_interest_flag = 'Y'
2415: AND TRUNC(P_check_date) > TRUNC(due_date)
2416: AND payment_num = P_payment_num