APPS.FA_GAINLOSS_MIS_PKG dependencies on FA_FISCAL_YEAR

Line 706: FROM FA_FISCAL_YEAR FY1, FA_FISCAL_YEAR FY2

702: h_same_fy := 0;
703:
704: select decode(fy1.fiscal_year, fy2.fiscal_year,1,0)
705: INTO h_same_fy
706: FROM FA_FISCAL_YEAR FY1, FA_FISCAL_YEAR FY2
707: WHERE trunc(h_date_retired) between fy1.start_date and fy1.end_date
708: AND trunc(h_deprn_start_date)
709: between fy2.start_date and fy2.end_date
710: AND fy1.fiscal_year_name = h_fiscal_year_name

Line 746: FROM FA_FISCAL_YEAR FISCAL

742:
743:
744: SELECT FISCAL.FISCAL_YEAR
745: INTO h_ret_fiscalyr
746: FROM FA_FISCAL_YEAR FISCAL
747: WHERE trunc(h_ret_prorate_date)
748: between START_DATE and END_DATE
749: AND fiscal_year_name = h_fiscal_year_name;
750:

Line 772: from fa_fiscal_year

768: if h_ret_fiscalyr > h_cpd_fiscal_year then
769:
770: select trunc(start_date)
771: into h_ret_prorate_date
772: from fa_fiscal_year
773: where fiscal_year = h_ret_fiscalyr
774: and fiscal_year_name = h_fiscal_year_name;
775: else
776: SELECT start_date

Line 778: FROM fa_fiscal_year

774: and fiscal_year_name = h_fiscal_year_name;
775: else
776: SELECT start_date
777: INTO h_ret_prorate_date
778: FROM fa_fiscal_year
779: where fiscal_year = h_cpd_fiscal_year
780: and fiscal_year_name = h_fiscal_year_name;
781: end if;
782: