DBA Data[Home] [Help]

APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INTEREST_PERIODS

Line 1352: FROM ap_payment_schedules, ap_interest_periods

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: