DBA Data[Home] [Help]

APPS.JG_RX_FAREG dependencies on FA_RATES

Line 1152: -- of the asset (X_life_of_asset) when joining to fa_rates.

1148: FA_RX_UTIL_PKG.debug('METHOD ID= ' || to_char(JG_RX_FAREG.var.method_id));
1149:
1150: -- Fix for Bug #5384045. To find the correct rate, we need to use
1151: -- the current year of the asset's life rather than the entire life
1152: -- of the asset (X_life_of_asset) when joining to fa_rates.
1153: SELECT fiscal_year
1154: INTO X_current_fiscal_year
1155: FROM fa_deprn_periods
1156: WHERE book_type_code = PARM.p_book_type_code

Line 1178: FROM fa_rates

1174: X_year_of_life := X_current_fiscal_year - X_prorate_fiscal_year + 1;
1175:
1176: SELECT rate
1177: INTO JG_RX_FAREG.var.deprn_rate
1178: FROM fa_rates
1179: WHERE method_id = JG_RX_FAREG.var.method_id
1180: AND year = X_year_of_life
1181: AND period_placed_in_service = (SELECT period_num
1182: FROM fa_calendar_periods