APPS.AP_DBI_PKG dependencies on AP_INVOICE_PAYMENTS

Line 319: FROM ap_invoice_payments aip, ap_checks ac,

315: AND aps.invoice_id = interest.invoice_id;
316:
317: CURSOR invoice_payments_cur IS
318: SELECT aip.invoice_payment_id
319: FROM ap_invoice_payments aip, ap_checks ac,
320: ap_selected_invoice_checks sic
321: WHERE aip.check_id = ac.check_id
322: AND sic.check_id = ac.check_id
323: AND sic.checkrun_name = p_checkrun_name;

Line 386: ELSIF (p_key_table = 'AP_INVOICE_PAYMENTS_ALL') THEN

382: p_calling_sequence => l_curr_calling_sequence);
383: END LOOP;
384: CLOSE sched_cur;
385:
386: ELSIF (p_key_table = 'AP_INVOICE_PAYMENTS_ALL') THEN
387:
388: OPEN invoice_payments_cur;
389: LOOP
390: FETCH invoice_payments_cur

Line 395: (p_table_name => 'AP_INVOICE_PAYMENTS',

391: INTO l_invoice_pay_id;
392: EXIT WHEN invoice_payments_cur%NOTFOUND;
393:
394: AP_DBI_PKG.Maintain_DBI_Summary
395: (p_table_name => 'AP_INVOICE_PAYMENTS',
396: p_operation => 'I',
397: p_key_value1 => l_invoice_pay_id,
398: p_calling_sequence => l_curr_calling_sequence);
399: END LOOP;