APPS.JL_BR_INTEREST_HANDLING dependencies on AP_PAYMENT_SCHEDULES

Line 336: -- from ap_payment_schedules

332: AND l3.lookup_code = 'PERCENT';
333:
334: -- ***********************************************************
335: -- Get the interest rate from(GA2) and due_date
336: -- from ap_payment_schedules
337: -- ***********************************************************
338: SELECT substr(global_attribute1, 1, 15),
339: nvl(to_number(substr(global_attribute2, 1, 15)), 0),
340: due_date

Line 342: FROM ap_payment_schedules

338: SELECT substr(global_attribute1, 1, 15),
339: nvl(to_number(substr(global_attribute2, 1, 15)), 0),
340: due_date
341: INTO l_interest_type, l_rate_amount, l_due_date
342: FROM ap_payment_schedules
343: WHERE invoice_id = P_invoice_original
344: AND payment_num = P_payment_num_org;
345:
346: -- *********************************************************