APPS.JG_RX_FAREG dependencies on FA_FISCAL_YEAR

Line 999: FROM fa_fiscal_year FY,

995: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_starting_depreciation_year()+');
996:
997: SELECT FY.fiscal_year
998: INTO X_ret
999: FROM fa_fiscal_year FY,
1000: fa_convention_types CT,
1001: fa_books BO
1002: WHERE CT.prorate_convention_code = BO.prorate_convention_code
1003: AND FY.fiscal_year_name = CT.fiscal_year_name

Line 1169: fa_fiscal_year fy,

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
1173: AND bc.book_type_code = PARM.p_book_type_code

Line 2347: FROM fa_fiscal_year FY,

2343: INTO X_fiscal_year_start_date,
2344: X_fiscal_year_end_date,
2345: X_deprn_calendar,
2346: X_prorate_calendar
2347: FROM fa_fiscal_year FY,
2348: fa_book_controls BC
2349: WHERE FY.fiscal_year = X_fiscal_year
2350: AND FY.fiscal_year_name = BC.fiscal_year_name
2351: AND BC.book_type_code = PARM.p_book_type_code;