APPS.JL_BR_INTEREST_HANDLING dependencies on AP_INVOICES

Line 162: -- Get the payment_date from ap_invoices (interest invoice)

158: WHERE invoice_id = P_invoice_original
159: AND payment_num = P_payment_num_org;
160:
161: -- *********************************************************
162: -- Get the payment_date from ap_invoices (interest invoice)
163: -- *********************************************************
164: SELECT invoice_date
165: INTO l_check_date
166: FROM ap_invoices

Line 166: FROM ap_invoices

162: -- Get the payment_date from ap_invoices (interest invoice)
163: -- *********************************************************
164: SELECT invoice_date
165: INTO l_check_date
166: FROM ap_invoices
167: WHERE invoice_id = P_invoice_related;
168:
169:
170: -- *********************************************************

Line 189: FROM ap_invoices ai, fnd_currencies_vl fc

185: -- Get the currency symbol
186: -- *********************************************************
187: SELECT fc.symbol
188: INTO l_currency_symbol
189: FROM ap_invoices ai, fnd_currencies_vl fc
190: WHERE ai.invoice_currency_code = fc.currency_code
191: AND ai.invoice_id = P_invoice_original;
192:
193: l_invoice_description := l_nls_interest || ' ' || to_char(l_invoice_days_late)

Line 199: UPDATE ap_invoices

195: ELSE
196: l_invoice_description := 'Invalid Interest Type: ' || l_interest_type;
197: END IF;
198:
199: UPDATE ap_invoices
200: SET description = l_invoice_description
201: WHERE invoice_id = P_invoice_related;
202:
203: EXCEPTION