APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_CALENDAR_TYPES

Line 11: g_num_per_fy fa_calendar_types.number_per_fiscal_year%TYPE;

7: g_period_num1 fa_calendar_periods.period_num%TYPE;
8: g_period_num2 fa_calendar_periods.period_num%TYPE;
9: g_end_date1 fa_calendar_periods.end_date%TYPE;
10: g_end_date2 fa_calendar_periods.end_date%TYPE;
11: g_num_per_fy fa_calendar_types.number_per_fiscal_year%TYPE;
12: g_switched_whatif NUMBER :=0; --- BUG # 7193797 : Added to calculate the global Count
13: g_switched_recal NUMBER :=0; ---Bug 8639499
14: g_switched_add NUMBER :=0; --bug 8726493
15: g_previous_assetid NUMBER :=0; --Bug 13504981

Line 1921: fa_calendar_types cal_ty

1917: l_fy_end_date,
1918: l_fy_mid_year_date
1919: FROM fa_calendar_periods cp,
1920: fa_fiscal_year fy,
1921: fa_calendar_types cal_ty
1922: WHERE fy.fiscal_year =
1923: decode(mod(p_period_counter,cal_ty.NUMBER_PER_FISCAL_YEAR),0,
1924: (floor(p_period_counter/cal_ty.NUMBER_PER_FISCAL_YEAR)-1),
1925: floor(p_period_counter/cal_ty.NUMBER_PER_FISCAL_YEAR)

Line 2094: fa_calendar_types cal_ty

2090: l_fy_end_date,
2091: l_fy_mid_year_date
2092: FROM fa_calendar_periods cp,
2093: fa_fiscal_year fy,
2094: fa_calendar_types cal_ty
2095: WHERE fy.fiscal_year =
2096: decode(mod(p_period_counter,cal_ty.NUMBER_PER_FISCAL_YEAR),0,
2097: (floor(p_period_counter/cal_ty.NUMBER_PER_FISCAL_YEAR)-1),
2098: floor(p_period_counter/cal_ty.NUMBER_PER_FISCAL_YEAR)

Line 2719: -- bug 8256548 : removed FA_FISCAL_YEAR and FA_CALENDAR_TYPES

2715: and BK2.set_of_books_id = p_set_of_books_id ;
2716:
2717: -- Get Recoverable cost for Group Asset
2718: -- For Reclass, get sum of delta recoverable cost and salvage value from member asset
2719: -- bug 8256548 : removed FA_FISCAL_YEAR and FA_CALENDAR_TYPES
2720: cursor GP_GET_REC_COST is
2721: select sum(BK2.COST -nvl(BK1.COST,0))
2722: - decode(BK3.SALVAGE_TYPE,
2723: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),

Line 2826: FA_CALENDAR_TYPES CT,

2822: -- Get period close date
2823: cursor C_PERIOD_CLOSE_DATE is
2824: select CP.END_DATE
2825: from FA_CALENDAR_PERIODS CP,
2826: FA_CALENDAR_TYPES CT,
2827: FA_FISCAL_YEAR FY,
2828: FA_BOOK_CONTROLS BC
2829: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2830: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE

Line 2841: FA_CALENDAR_TYPES CT,

2837:
2838: cursor C_PERIOD_CLOSE_DATE_MRC is
2839: select CP.END_DATE
2840: from FA_CALENDAR_PERIODS CP,
2841: FA_CALENDAR_TYPES CT,
2842: FA_FISCAL_YEAR FY,
2843: FA_BOOK_CONTROLS BC
2844: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2845: and BC.set_of_books_id = p_set_of_books_id

Line 3125: from FA_CALENDAR_TYPES CT,

3121:
3122: cursor C_GET_NPFY
3123: is
3124: select CT.number_per_fiscal_year
3125: from FA_CALENDAR_TYPES CT,
3126: FA_BOOK_CONTROLS BC
3127: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
3128: and BC.BOOK_TYPE_CODE= p_book_type_code;
3129:

Line 3133: from FA_CALENDAR_TYPES CT,

3129:
3130: cursor C_GET_NPFY_MRC
3131: is
3132: select CT.number_per_fiscal_year
3133: from FA_CALENDAR_TYPES CT,
3134: FA_MC_BOOK_CONTROLS MBC,
3135: FA_BOOK_CONTROLS BC
3136: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
3137: and BC.BOOK_TYPE_CODE= p_book_type_code

Line 4398: FA_CALENDAR_TYPES CT,

4394: cursor C_PERIOD_END_DATE is
4395: select FY.START_DATE,
4396: CP.END_DATE
4397: from FA_CALENDAR_PERIODS CP,
4398: FA_CALENDAR_TYPES CT,
4399: FA_FISCAL_YEAR FY,
4400: FA_BOOK_CONTROLS BC
4401: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
4402: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE

Line 4414: FA_CALENDAR_TYPES CT,

4410: cursor C_PERIOD_END_DATE_M is
4411: select FY.START_DATE,
4412: CP.END_DATE
4413: from FA_CALENDAR_PERIODS CP,
4414: FA_CALENDAR_TYPES CT,
4415: FA_FISCAL_YEAR FY,
4416: FA_MC_BOOK_CONTROLS MBC,
4417: FA_BOOK_CONTROLS BC
4418: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE