[Home] [Help]
1348: ELSE
1349: BEGIN
1350: SELECT annual_interest_rate , due_date
1351: INTO l_rate, l_due_date
1352: FROM ap_payment_schedules, ap_interest_periods
1353: WHERE payment_num = l_payment_num
1354: AND invoice_id = P_invoice_id
1355: AND trunc(due_date+1) BETWEEN trunc(start_date) AND trunc(end_date);
1356: