APPS.AP_BAL_PKG dependencies on AP_VIEW_PREPAYS_FR_PREPAY_V

Line 82: FROM ap_view_prepays_fr_prepay_v AVPFPV

78: BEGIN
79: BEGIN
80: SELECT MAX(AVPFPV.accounting_date)
81: INTO ld_settlement_date
82: FROM ap_view_prepays_fr_prepay_v AVPFPV
83: WHERE AVPFPV.prepay_id = p_invoice_id
84: AND AVPFPV.prepay_line_number = p_line_number;
85: EXCEPTION
86: WHEN no_data_found THEN

Line 278: FROM ap_view_prepays_fr_prepay_v avprpv

274: ' ,(SELECT avprpv.org_id org_id
275: ,avprpv.prepay_id prepay_id
276: ,avprpv.prepay_line_number prepay_line_number
277: ,avprpv.prepay_amount_applied prepay_amount_applied
278: FROM ap_view_prepays_fr_prepay_v avprpv
279: WHERE NVL(avprpv.accounting_date,:gd_from_date) <= :gd_from_date) avprpv ';
280: gc_where_clause := ' AND ai.invoice_id = aip.invoice_id(+) '
281: ||' AND aip.check_id = ac.check_id(+) '
282: ||' AND ail.invoice_id = avprpv.prepay_id(+) '