APPS.FV_DUE_DATE_CALCULATION dependencies on FV_INVOICE_RETURN_DATES

Line 760: FROM fv_invoice_return_dates

756: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'YES IT IS NOT NULL');
757: END IF;
758: SELECT COUNT(*)
759: INTO v_tot_inv_retn
760: FROM fv_invoice_return_dates
761: WHERE invoice_returned_date > (original_invoice_received_date
762: + v_invoice_return_days)
763: AND invoice_id = v_invoice_id;
764: IF(v_tot_inv_retn > 0) THEN /* Total No of Invoice returned */

Line 775: FROM fv_invoice_return_dates

771: SELECT SUM(invoice_returned_date -
772: original_invoice_received_date -
773: v_invoice_return_days)
774: INTO v_diff_days
775: FROM fv_invoice_return_dates
776: WHERE (invoice_returned_date -
777: original_invoice_received_date)
778: > v_invoice_return_days
779: AND invoice_id = v_invoice_id;