DBA Data[Home] [Help]

APPS.JG_RX_FAREG dependencies on FA_CALENDAR_PERIODS

Line 1161: FROM fa_calendar_periods cp,

1157: AND period_name = PARM.p_period_from;
1158:
1159: SELECT fy.fiscal_year
1160: INTO X_prorate_fiscal_year
1161: FROM fa_calendar_periods cp,
1162: fa_fiscal_year fy,
1163: fa_book_controls bc
1164: WHERE fy.fiscal_year_name = bc.fiscal_year_name
1165: AND cp.calendar_type = bc.prorate_calendar

Line 1182: FROM fa_calendar_periods

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
1183: WHERE calendar_type = X_deprn_calendar -- X_deprn_calendar is retrieved in Get_fiscal_year_date()
1184: AND JG_RX_FAREG.var.prorate_date BETWEEN start_date -- X_prorate_date is retrieved in Get_fiscal_year_date()
1185: AND end_date);
1186: