DBA Data[Home] [Help]

APPS.FV_ECON_BENF_DISC_PVT dependencies on FV_VALUE_OF_FUND_PERIODS

Line 473: from fv_value_of_fund_periods

469: X_Current_Value_Of_Funds_Rate NUMBER;
470: BEGIN
471: select CURR_VALUE_OF_FUNDS_PERCENT
472: into X_Current_Value_Of_Funds_Rate
473: from fv_value_of_fund_periods
474: where trunc(X_Payment_Date) between trunc(effective_start_date)
475: and trunc(nvl(effective_end_date, X_Payment_Date));
476:
477: X_CVOF_Rate := X_Current_Value_Of_Funds_Rate;

Line 550: X_CVOF_Rate FV_VALUE_OF_FUND_PERIODS.CURR_VALUE_OF_FUNDS_PERCENT%TYPE;

546: -- Bug 11834795
547: X_Terms_Id AP_INVOICES.TERMS_ID%TYPE;
548: X_Payment_Date DATE;
549: X_Effective_Discount_Rate FV_DISCOUNTED_INVOICES.EFFECTIVE_DISCOUNT_PERCENT%TYPE;
550: X_CVOF_Rate FV_VALUE_OF_FUND_PERIODS.CURR_VALUE_OF_FUNDS_PERCENT%TYPE;
551: X_terms_type FV_TERMS_TYPES.TERMS_TYPE%TYPE;
552: X_Err_Nbr NUMBER ;
553: X_Err_Stage VARCHAR2(120);
554: --MOAC changes: Removed the org_id parameter in the call to FV_INSTALL.enabled