334: for i in prepayment_invoices
335: loop
336: l_prepay_amount_remaining:=0;
337: l_prepay_amount_remaining:=
338: AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(i.invoice_id);
339: if(l_prepay_amount_remaining>0 ) then
340: prepay_count:=prepay_count+1;
341: end if;
342: end loop;
344: for i in prepayment_invoices_org
345: loop
346: l_prepay_amount_remaining:=0;
347: l_prepay_amount_remaining:=
348: AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(i.invoice_id);
349: if(l_prepay_amount_remaining>0 ) then
350: prepay_count:=prepay_count+1;
351: end if;
352: end loop;
394: loop
395: if(i.earliest_settlement_date<=(sysdate)) then
396: l_prepay_amount_remaining:=0;
397: l_prepay_amount_remaining:=
398: AP_INVOICES_UTILITY_PKG.get_prepay_amount_remaining(i.invoice_id);
399: if(l_prepay_amount_remaining>0 ) then
400: prepay_count:=prepay_count+1;
401: end if;
402: end if;