APPS.FV_DUE_DATE_CALCULATION dependencies on FV_INVOICE_RETURN_DATES

Line 748: FROM fv_invoice_return_dates

744: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'YES IT IS NOT NULL');
745: END IF;
746: SELECT COUNT(*)
747: INTO v_tot_inv_retn
748: FROM fv_invoice_return_dates
749: WHERE invoice_returned_date > (original_invoice_received_date
750: + v_invoice_return_days)
751: AND invoice_id = v_invoice_id;
752: IF(v_tot_inv_retn > 0) THEN /* Total No of Invoice returned */

Line 763: FROM fv_invoice_return_dates

759: SELECT SUM(invoice_returned_date -
760: original_invoice_received_date -
761: v_invoice_return_days)
762: INTO v_diff_days
763: FROM fv_invoice_return_dates
764: WHERE (invoice_returned_date -
765: original_invoice_received_date)
766: > v_invoice_return_days
767: AND invoice_id = v_invoice_id;