APPS.JG_RX_FAREG dependencies on FA_FISCAL_YEAR

Line 992: FROM fa_fiscal_year FY,

988: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_starting_depreciation_year()+');
989:
990: SELECT FY.fiscal_year
991: INTO X_ret
992: FROM fa_fiscal_year FY,
993: fa_convention_types CT,
994: fa_books BO
995: WHERE CT.prorate_convention_code = BO.prorate_convention_code
996: AND FY.fiscal_year_name = CT.fiscal_year_name

Line 1162: fa_fiscal_year fy,

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

Line 2331: FROM fa_fiscal_year FY,

2327: INTO X_fiscal_year_start_date,
2328: X_fiscal_year_end_date,
2329: X_deprn_calendar,
2330: X_prorate_calendar
2331: FROM fa_fiscal_year FY,
2332: fa_book_controls BC
2333: WHERE FY.fiscal_year = X_fiscal_year
2334: AND FY.fiscal_year_name = BC.fiscal_year_name
2335: AND BC.book_type_code = PARM.p_book_type_code;