APPS.FA_GAINLOSS_RET_PKG dependencies on FA_FISCAL_YEAR

Line 116: fa_fiscal_year fy

112: SELECT to_number (to_char (cp.start_date, 'J'))
113: INTO h_cpp_jstartdate
114: FROM fa_deprn_periods dp,
115: fa_calendar_periods cp,
116: fa_fiscal_year fy
117: WHERE cp.calendar_type = h_d_cal
118: AND fy.fiscal_year_name = h_fiscal_year_name
119: AND fy.fiscal_year = h_cpd_fy
120: AND dp.fiscal_year = fy.fiscal_year

Line 617: from fa_fiscal_year

613: and bk.ret_prorate_date between start_date and end_date;
614:
615: select fiscal_year
616: into h_fiscal_year
617: from fa_fiscal_year
618: where fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
619: and bk.ret_prorate_date between start_date and end_date;
620:
621: exception