DBA Data[Home] [Help]

APPS.FV_ECON_BENF_DISC_PVT dependencies on FV_VALUE_OF_FUND_PERIODS

Line 458: from fv_value_of_fund_periods

454: X_Current_Value_Of_Funds_Rate NUMBER;
455: BEGIN
456: select CURR_VALUE_OF_FUNDS_PERCENT
457: into X_Current_Value_Of_Funds_Rate
458: from fv_value_of_fund_periods
459: where trunc(X_Payment_Date) between trunc(effective_start_date)
460: and trunc(nvl(effective_end_date, X_Payment_Date));
461:
462: X_CVOF_Rate := X_Current_Value_Of_Funds_Rate;

Line 532: X_CVOF_Rate FV_VALUE_OF_FUND_PERIODS.CURR_VALUE_OF_FUNDS_PERCENT%TYPE;

528: --------------End of Comments---------------------------------------*/
529: x_Due_Date AP_SELECTED_INVOICES.DUE_DATE%TYPE;
530: X_Payment_Date DATE;
531: X_Effective_Discount_Rate FV_DISCOUNTED_INVOICES.EFFECTIVE_DISCOUNT_PERCENT%TYPE;
532: X_CVOF_Rate FV_VALUE_OF_FUND_PERIODS.CURR_VALUE_OF_FUNDS_PERCENT%TYPE;
533: X_terms_type FV_TERMS_TYPES.TERMS_TYPE%TYPE;
534: X_Err_Nbr NUMBER ;
535: X_Err_Stage VARCHAR2(120);
536: --MOAC changes: Removed the org_id parameter in the call to FV_INSTALL.enabled