APPS.FA_GAINLOSS_MIS_PKG dependencies on FA_FISCAL_YEAR

Line 711: FROM FA_FISCAL_YEAR FY1, FA_FISCAL_YEAR FY2

707: h_same_fy := 0;
708:
709: select decode(fy1.fiscal_year, fy2.fiscal_year,1,0)
710: INTO h_same_fy
711: FROM FA_FISCAL_YEAR FY1, FA_FISCAL_YEAR FY2
712: WHERE trunc(h_date_retired) between fy1.start_date and fy1.end_date
713: AND trunc(h_deprn_start_date)
714: between fy2.start_date and fy2.end_date
715: AND fy1.fiscal_year_name = h_fiscal_year_name

Line 753: FROM FA_FISCAL_YEAR FISCAL

749: */
750:
751: SELECT FISCAL.FISCAL_YEAR
752: INTO h_ret_fiscalyr
753: FROM FA_FISCAL_YEAR FISCAL
754: WHERE trunc(h_ret_prorate_date)
755: between START_DATE and END_DATE
756: AND fiscal_year_name = h_fiscal_year_name;
757:

Line 777: from fa_fiscal_year

773: if h_ret_fiscalyr > h_cpd_fiscal_year then
774:
775: select trunc(start_date)
776: into h_ret_prorate_date
777: from fa_fiscal_year
778: where fiscal_year = h_ret_fiscalyr
779: and fiscal_year_name = h_fiscal_year_name;
780: else
781: SELECT start_date

Line 783: FROM fa_fiscal_year

779: and fiscal_year_name = h_fiscal_year_name;
780: else
781: SELECT start_date
782: INTO h_ret_prorate_date
783: FROM fa_fiscal_year
784: where fiscal_year = h_cpd_fiscal_year
785: and fiscal_year_name = h_fiscal_year_name;
786: end if;
787: