APPS.FA_CDE_PKG dependencies on FA_FISCAL_YEAR

Line 11: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;

7: g_use_annual_round integer:= ROUND_WITH_RESTRICTIONS;
8: primary_cost NUMBER;
9: g_pre_period_name fa_calendar_periods.period_name%TYPE;
10: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;
11: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;
12:
13:
14:
15: Function faxgpr (

Line 452: fa_fiscal_year fy,

448: h_curr_fy,
449: h_dpis,
450: h_deprn_start_date
451: from fa_books bk,
452: fa_fiscal_year fy,
453: fa_book_controls bc,
454: fa_book_controls bc2
455: where bc.book_type_code = X_Book_Type_Code
456: and fy.fiscal_year_name = bc.fiscal_year_name

Line 470: from fa_fiscal_year fy,

466: elsif (X_Short_Fiscal_Year_Flag = 'NO' and
467: X_Conversion_Date is not NULL) then
468: select count(*)
469: into h_conversion_year
470: from fa_fiscal_year fy,
471: fa_book_controls bc
472: where bc.book_type_code = X_Book_Type_Code
473: and bc.fiscal_year_name = fy.fiscal_year_name
474: and X_Conversion_Date between fy.start_date and

Line 4264: from fa_calendar_periods cp, fa_fiscal_year fy

4260:
4261: /* -- FIGURE OUT THE PERIOD_COUNTER for the current fyctr and perd_ctr
4262: select fy.fiscal_year * h_num_per_fy + cp.period_num
4263: into perd_c
4264: from fa_calendar_periods cp, fa_fiscal_year fy
4265: where cp.period_num = perd_ctr
4266: and fy.fiscal_year = fyctr
4267: and cp.calendar_type = h_calendar_type
4268: and cp.start_date >= fy.start_date

Line 4277: from fa_calendar_periods cp, fa_fiscal_year fy

4273: -- FIGURE OUT THE PERIOD_NAME for the current fyctr and perd_ctr
4274: if perd_ctr <> nvl(g_pre_period_ctr, 0) or fyctr <> nvl(g_pre_fyctr,0) then
4275:
4276: select cp.period_name into perd_name
4277: from fa_calendar_periods cp, fa_fiscal_year fy
4278: where cp.calendar_type = h_calendar_type and
4279: cp.period_num = perd_ctr and
4280: cp.start_date >= fy.start_date and
4281: cp.end_date <= fy.end_date and