APPS.FA_CDE_PKG dependencies on FA_FISCAL_YEAR

Line 12: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;

8: g_use_annual_round INTEGER:= ROUND_WITH_RESTRICTIONS;
9: primary_cost NUMBER;
10: g_pre_period_name fa_calendar_periods.period_name%TYPE;
11: g_pre_period_ctr fa_calendar_periods.period_num%TYPE;
12: g_pre_fyctr fa_fiscal_year.fiscal_year%TYPE;
13:
14:
15: FUNCTION faxgpr (
16: X_dpr_ptr fa_std_types.dpr_struct,

Line 469: fa_fiscal_year fy,

465: h_curr_fy,
466: h_dpis,
467: h_deprn_start_date
468: FROM fa_books bk,
469: fa_fiscal_year fy,
470: fa_book_controls bc,
471: fa_book_controls bc2
472: WHERE bc.book_type_code = X_Book_Type_Code
473: AND fy.fiscal_year_name = bc.fiscal_year_name

Line 487: FROM fa_fiscal_year fy,

483: ELSIF (X_Short_Fiscal_Year_Flag = 'NO' AND
484: X_Conversion_Date IS NOT NULL) THEN
485: SELECT COUNT(*)
486: INTO h_conversion_year
487: FROM fa_fiscal_year fy,
488: fa_book_controls bc
489: WHERE bc.book_type_code = X_Book_Type_Code
490: AND bc.fiscal_year_name = fy.fiscal_year_name
491: AND X_Conversion_Date BETWEEN fy.start_date AND

Line 2341: FA_FISCAL_YEAR fy

2337: INTO dpis_fy,dpis_perd_num
2338: FROM FA_BOOKS bk,
2339: FA_CALENDAR_PERIODS CL,
2340: FA_BOOK_CONTROLS BC,
2341: FA_FISCAL_YEAR fy
2342: WHERE bk.asset_id = dpr.asset_id
2343: AND bk.book_type_code = dpr.book
2344: AND bk.date_ineffective is null
2345: AND BC.book_type_code = dpr.book

Line 4910: FROM fa_calendar_periods cp, fa_fiscal_year fy

4906: SELECT cp.period_name,
4907: fy.fiscal_year * h_num_per_fy + cp.period_num
4908: INTO perd_name,
4909: l_period_counter
4910: FROM fa_calendar_periods cp, fa_fiscal_year fy
4911: WHERE cp.calendar_type = h_calendar_type AND
4912: cp.period_num = perd_ctr AND
4913: cp.start_date >= fy.start_date AND
4914: cp.end_date <= fy.end_date AND