APPS.JL_BR_INTEREST_HANDLING dependencies on AP_PAYMENT_SCHEDULES

Line 151: -- from ap_payment_schedules

147: AND l3.lookup_code = 'PERCENT';
148:
149: -- ***********************************************************
150: -- Get the interest rate from(GA2) and due_date
151: -- from ap_payment_schedules
152: -- ***********************************************************
153: SELECT substr(global_attribute1, 1, 15),
154: nvl(to_number(substr(global_attribute2, 1, 15)), 0),
155: due_date

Line 157: FROM ap_payment_schedules

153: SELECT substr(global_attribute1, 1, 15),
154: nvl(to_number(substr(global_attribute2, 1, 15)), 0),
155: due_date
156: INTO l_interest_type, l_rate_amount, l_due_date
157: FROM ap_payment_schedules
158: WHERE invoice_id = P_invoice_original
159: AND payment_num = P_payment_num_org;
160:
161: -- *********************************************************