75: BEGIN
76: BEGIN
77: SELECT MAX(AVPFPV.accounting_date)
78: INTO ld_settlement_date
79: FROM ap_view_prepays_fr_prepay_v AVPFPV
80: WHERE AVPFPV.prepay_id = p_invoice_id
81: AND AVPFPV.prepay_line_number = p_line_number;
82: EXCEPTION
83: WHEN no_data_found THEN
267: ' ,(SELECT avprpv.org_id org_id
268: ,avprpv.prepay_id prepay_id
269: ,avprpv.prepay_line_number prepay_line_number
270: ,avprpv.prepay_amount_applied prepay_amount_applied
271: FROM ap_view_prepays_fr_prepay_v avprpv
272: WHERE NVL(avprpv.accounting_date,:gd_from_date) <= :gd_from_date) avprpv ';
273: gc_where_clause := ' AND ai.invoice_id = aip.invoice_id(+) '
274: ||' AND aip.check_id = ac.check_id(+) '
275: ||' AND ail.invoice_id = avprpv.prepay_id(+) '