eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_FISCAL_YEAR

Line 5: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;

1: PACKAGE BODY FA_CALC_DEPRN_BASIS1_PKG as
2: /* $Header: faxcdb1b.pls 120.96.12020000.4 2013/03/19 18:01:39 dvjoshi ship $ */
3: -- global variables
4: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
5: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;
6: g_fiscal_year2 fa_fiscal_year.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;

Line 6: g_fiscal_year2 fa_fiscal_year.fiscal_year%TYPE;

2: /* $Header: faxcdb1b.pls 120.96.12020000.4 2013/03/19 18:01:39 dvjoshi ship $ */
3: -- global variables
4: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
5: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;
6: g_fiscal_year2 fa_fiscal_year.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;

Line 1514: from FA_FISCAL_YEAR fy,

1510: fy.end_date fy_end_date,
1511: fy.mid_year_date fy_mid_year_date,
1512: dp.calendar_period_open_date cp_start_date,
1513: dp.calendar_period_close_date cp_end_date
1514: from FA_FISCAL_YEAR fy,
1515: FA_DEPRN_PERIODS dp,
1516: FA_BOOK_CONTROLS bc
1517: where bc.book_type_code = dp.book_type_code
1518: and fy.fiscal_year = dp.fiscal_year

Line 1530: from FA_FISCAL_YEAR fy,

1526: fy.end_date fy_end_date,
1527: fy.mid_year_date fy_mid_year_date,
1528: dp.calendar_period_open_date cp_start_date,
1529: dp.calendar_period_close_date cp_end_date
1530: from FA_FISCAL_YEAR fy,
1531: FA_MC_DEPRN_PERIODS dp,
1532: FA_MC_BOOK_CONTROLS mbc,
1533: FA_BOOK_CONTROLS BC
1534: where bc.book_type_code = dp.book_type_code

Line 1920: fa_fiscal_year fy,

1916: l_fy_start_date,
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),

Line 2093: fa_fiscal_year fy,

2089: l_fy_start_date,
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),

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 2827: FA_FISCAL_YEAR FY,

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
2831: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME

Line 2842: FA_FISCAL_YEAR FY,

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
2846: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE

Line 4125: from FA_FISCAL_YEAR fy,

4121: -- Query end date of period
4122: cursor C_GET_DATE is
4123: select fy.start_date fy_start_date,
4124: dp.calendar_period_close_date cp_end_date
4125: from FA_FISCAL_YEAR fy,
4126: FA_DEPRN_PERIODS dp,
4127: FA_BOOK_CONTROLS bc
4128: where bc.book_type_code = dp.book_type_code
4129: and fy.fiscal_year = dp.fiscal_year

Line 4137: from FA_FISCAL_YEAR fy,

4133:
4134: cursor C_GET_DATE_M is
4135: select fy.start_date fy_start_date,
4136: dp.calendar_period_close_date cp_end_date
4137: from FA_FISCAL_YEAR fy,
4138: FA_MC_DEPRN_PERIODS dp,
4139: FA_MC_BOOK_CONTROLS mbc,
4140: FA_BOOK_CONTROLS BC
4141: where bc.book_type_code = dp.book_type_code

Line 4399: FA_FISCAL_YEAR FY,

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
4403: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME

Line 4415: FA_FISCAL_YEAR FY,

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
4419: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE