DBA Data[Home] [Help]

APPS.JG_RX_FAREG dependencies on FA_CALENDAR_PERIODS

Line 1168: FROM fa_calendar_periods cp,

1164: AND period_name = PARM.p_period_from;
1165:
1166: SELECT fy.fiscal_year
1167: INTO X_prorate_fiscal_year
1168: FROM fa_calendar_periods cp,
1169: fa_fiscal_year fy,
1170: fa_book_controls bc
1171: WHERE fy.fiscal_year_name = bc.fiscal_year_name
1172: AND cp.calendar_type = bc.prorate_calendar

Line 1191: FROM fa_calendar_periods

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
1192: WHERE calendar_type = X_deprn_calendar -- X_deprn_calendar is retrieved in Get_fiscal_year_date()
1193: AND JG_RX_FAREG.var.prorate_date BETWEEN start_date -- X_prorate_date is retrieved in Get_fiscal_year_date()
1194: AND end_date);
1195: ELSE