APPS.FA_GAINLOSS_RET_PKG dependencies on FA_FISCAL_YEAR

Line 510: FROM FA_FISCAL_YEAR FY1, FA_FISCAL_YEAR FY2

506: h_same_fy := 0;
507:
508: select decode(fy1.fiscal_year, fy2.fiscal_year,1,0)
509: INTO h_same_fy
510: FROM FA_FISCAL_YEAR FY1, FA_FISCAL_YEAR FY2
511: WHERE trunc(h_date_retired) between fy1.start_date and fy1.end_date
512: AND trunc(h_deprn_start_date)
513: between fy2.start_date and fy2.end_date
514: AND fy1.fiscal_year_name = h_fiscal_year_name

Line 529: FROM FA_FISCAL_YEAR FISCAL

525:
526:
527: SELECT FISCAL.FISCAL_YEAR
528: INTO h_ret_fiscalyr
529: FROM FA_FISCAL_YEAR FISCAL
530: WHERE trunc(h_ret_prorate_date)
531: between START_DATE and END_DATE
532: AND fiscal_year_name = h_fiscal_year_name;
533:

Line 547: from fa_fiscal_year

543: if h_ret_fiscalyr > h_cpd_fiscal_year then
544:
545: select trunc(start_date)
546: into h_ret_prorate_date
547: from fa_fiscal_year
548: where fiscal_year = h_ret_fiscalyr
549: and fiscal_year_name = h_fiscal_year_name;
550: else
551: SELECT start_date

Line 553: FROM fa_fiscal_year

549: and fiscal_year_name = h_fiscal_year_name;
550: else
551: SELECT start_date
552: INTO h_ret_prorate_date
553: FROM fa_fiscal_year
554: where fiscal_year = h_cpd_fiscal_year
555: and fiscal_year_name = h_fiscal_year_name;
556: end if;
557:

Line 852: fa_fiscal_year fy

848: SELECT to_number (to_char (cp.start_date, 'J'))
849: INTO h_cpp_jstartdate
850: FROM fa_deprn_periods dp,
851: fa_calendar_periods cp,
852: fa_fiscal_year fy
853: WHERE cp.calendar_type = h_d_cal
854: AND fy.fiscal_year_name = h_fiscal_year_name
855: AND fy.fiscal_year = h_cpd_fy
856: AND dp.fiscal_year = fy.fiscal_year