DBA Data[Home] [Help]

APPS.JG_RX_FAREG dependencies on FA_RATES

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

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

Line 1187: FROM fa_rates

1183: IF x_life_of_asset > X_year_of_life THEN
1184:
1185: SELECT rate
1186: INTO JG_RX_FAREG.var.deprn_rate
1187: FROM fa_rates
1188: WHERE method_id = JG_RX_FAREG.var.method_id
1189: AND year = X_year_of_life
1190: AND period_placed_in_service = (SELECT period_num
1191: FROM fa_calendar_periods