APPS.FII_SIZING_UTIL dependencies on AP_INVOICE_PAYMENTS_ALL

Line 565: ap_invoice_payments_all aip,

561: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
562: CURSOR c_cnt_rows IS
563: SELECT count(*) cnt
564: FROM
565: ap_invoice_payments_all aip,
566: ap_invoices_all ai
567: WHERE aip.last_update_date between p_from_date and p_to_date
568: AND aip.invoice_id = ai.invoice_id
569: AND ai.invoice_type_lookup_code <> 'EXPENSE REPORT';

Line 608: from ap_invoice_payments_all aip

604: p_to_date DATE,
605: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
606: CURSOR c_cnt_rows IS
607: select count(*) cnt
608: from ap_invoice_payments_all aip
609: WHERE aip.last_update_date between p_from_date and p_to_date;
610:
611:
612: BEGIN