APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_CALENDAR_TYPES

Line 12: g_num_per_fy fa_calendar_types.number_per_fiscal_year%TYPE;

8: g_period_num1 fa_calendar_periods.period_num%TYPE;
9: g_period_num2 fa_calendar_periods.period_num%TYPE;
10: g_end_date1 fa_calendar_periods.end_date%TYPE;
11: g_end_date2 fa_calendar_periods.end_date%TYPE;
12: g_num_per_fy fa_calendar_types.number_per_fiscal_year%TYPE;
13:
14: FUNCTION faxcdb(
15: rule_in IN fa_std_types.fa_deprn_rule_in_struct,
16: rule_out OUT NOCOPY fa_std_types.fa_deprn_rule_out_struct,

Line 1721: fa_calendar_types cal_ty

1717: l_fy_end_date,
1718: l_fy_mid_year_date
1719: FROM fa_calendar_periods cp,
1720: fa_fiscal_year fy,
1721: fa_calendar_types cal_ty
1722: WHERE fy.fiscal_year = floor(p_period_counter/cal_ty.NUMBER_PER_FISCAL_YEAR)
1723: AND fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1724: AND cal_ty.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1725: AND cp.calendar_type = cal_ty.calendar_type

Line 1886: fa_calendar_types cal_ty

1882: l_fy_end_date,
1883: l_fy_mid_year_date
1884: FROM fa_calendar_periods cp,
1885: fa_fiscal_year fy,
1886: fa_calendar_types cal_ty
1887: WHERE fy.fiscal_year = floor(p_period_counter/cal_ty.NUMBER_PER_FISCAL_YEAR)
1888: AND fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1889: AND cal_ty.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1890: AND cp.calendar_type = cal_ty.calendar_type

Line 2473: -- bug4943259: removed FA_FISCAL_YEAR and FA_CALENDAR_TYPES

2469: and TH.TRANSACTION_DATE_ENTERED <= l_period_close_date;
2470:
2471: -- Get Recoverable cost for Group Asset
2472: -- For Reclass, get sum of delta recoverable cost and salvage value from member asset
2473: -- bug4943259: removed FA_FISCAL_YEAR and FA_CALENDAR_TYPES
2474: cursor GP_GET_REC_COST is
2475: select sum(BK2.COST -nvl(BK1.COST,0))
2476: - decode(BK3.SALVAGE_TYPE,
2477: 'PCT', sum(BK2.COST -nvl(BK1.COST,0))* nvl(BK3.PERCENT_SALVAGE_VALUE,0),

Line 2582: FA_CALENDAR_TYPES CT,

2578: -- Get period close date
2579: cursor C_PERIOD_CLOSE_DATE is
2580: select CP.END_DATE
2581: from FA_CALENDAR_PERIODS CP,
2582: FA_CALENDAR_TYPES CT,
2583: FA_FISCAL_YEAR FY,
2584: FA_BOOK_CONTROLS BC
2585: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2586: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE

Line 2597: FA_CALENDAR_TYPES CT,

2593:
2594: cursor C_PERIOD_CLOSE_DATE_MRC is
2595: select CP.END_DATE
2596: from FA_CALENDAR_PERIODS CP,
2597: FA_CALENDAR_TYPES CT,
2598: FA_FISCAL_YEAR FY,
2599: FA_BOOK_CONTROLS_MRC_V BC
2600: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2601: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE

Line 2897: from FA_CALENDAR_TYPES CT,

2893:
2894: cursor C_GET_NPFY
2895: is
2896: select CT.number_per_fiscal_year
2897: from FA_CALENDAR_TYPES CT,
2898: FA_BOOK_CONTROLS BC
2899: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
2900: and BC.BOOK_TYPE_CODE= p_book_type_code;
2901:

Line 2905: from FA_CALENDAR_TYPES CT,

2901:
2902: cursor C_GET_NPFY_MRC
2903: is
2904: select CT.number_per_fiscal_year
2905: from FA_CALENDAR_TYPES CT,
2906: FA_BOOK_CONTROLS_MRC_V BC
2907: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
2908: and BC.BOOK_TYPE_CODE= p_book_type_code;
2909:

Line 3968: FA_CALENDAR_TYPES CT,

3964: cursor C_PERIOD_END_DATE is
3965: select FY.START_DATE,
3966: CP.END_DATE
3967: from FA_CALENDAR_PERIODS CP,
3968: FA_CALENDAR_TYPES CT,
3969: FA_FISCAL_YEAR FY,
3970: FA_BOOK_CONTROLS BC
3971: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
3972: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE

Line 3984: FA_CALENDAR_TYPES CT,

3980: cursor C_PERIOD_END_DATE_M is
3981: select FY.START_DATE,
3982: CP.END_DATE
3983: from FA_CALENDAR_PERIODS CP,
3984: FA_CALENDAR_TYPES CT,
3985: FA_FISCAL_YEAR FY,
3986: FA_BOOK_CONTROLS_MRC_V BC
3987: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
3988: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE