DBA Data[Home] [Help]

APPS.AP_DBI_PKG dependencies on AP_SELECTED_INVOICES

Line 297: FROM ap_selected_invoices interest

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

Line 303: FROM ap_selected_invoices interest,

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

Line 311: FROM ap_selected_invoices interest,

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