DBA Data[Home] [Help]

APPS.AP_DBI_PKG dependencies on AP_SELECTED_INVOICES

Line 300: FROM ap_selected_invoices interest

296: l_debug_info varchar2(100);
297:
298: CURSOR invoice_cur IS
299: SELECT interest.invoice_id
300: FROM ap_selected_invoices interest
301: WHERE interest.original_invoice_id is NOT NULL --Bug3293887
302: AND interest.checkrun_name = p_checkrun_name;
303:
304: CURSOR invoice_dist_cur IS

Line 306: FROM ap_selected_invoices interest,

302: AND interest.checkrun_name = p_checkrun_name;
303:
304: CURSOR invoice_dist_cur IS
305: SELECT aid.invoice_distribution_id, aid.invoice_id
306: FROM ap_selected_invoices interest,
307: ap_invoice_distributions aid
308: WHERE interest.original_invoice_id is NOT NULL --Bug3293887
309: AND interest.checkrun_name = p_checkrun_name
310: AND aid.invoice_id = interest.invoice_id;

Line 314: FROM ap_selected_invoices interest,

310: AND aid.invoice_id = interest.invoice_id;
311:
312: CURSOR sched_cur IS
313: SELECT aps.invoice_id, aps.payment_num
314: FROM ap_selected_invoices interest,
315: ap_payment_schedules aps
316: WHERE interest.original_invoice_id is NOT NULL --Bug3293887
317: AND interest.checkrun_name = p_checkrun_name
318: AND aps.invoice_id = interest.invoice_id;