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 6: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;

2: /* $Header: faxcdb1b.pls 120.67.12010000.4 2009/02/04 14:22:51 souroy ship $ */
3: -- global variables
4: g_log_level_rec fa_api_types.log_level_rec_type;
5: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
6: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;
7: g_fiscal_year2 fa_fiscal_year.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;

Line 7: g_fiscal_year2 fa_fiscal_year.fiscal_year%TYPE;

3: -- global variables
4: g_log_level_rec fa_api_types.log_level_rec_type;
5: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
6: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;
7: g_fiscal_year2 fa_fiscal_year.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;

Line 1389: from FA_FISCAL_YEAR fy,

1385: fy.end_date fy_end_date,
1386: fy.mid_year_date fy_mid_year_date,
1387: dp.calendar_period_open_date cp_start_date,
1388: dp.calendar_period_close_date cp_end_date
1389: from FA_FISCAL_YEAR fy,
1390: FA_DEPRN_PERIODS dp,
1391: FA_BOOK_CONTROLS bc
1392: where bc.book_type_code = dp.book_type_code
1393: and fy.fiscal_year = dp.fiscal_year

Line 1405: from FA_FISCAL_YEAR fy,

1401: fy.end_date fy_end_date,
1402: fy.mid_year_date fy_mid_year_date,
1403: dp.calendar_period_open_date cp_start_date,
1404: dp.calendar_period_close_date cp_end_date
1405: from FA_FISCAL_YEAR fy,
1406: FA_DEPRN_PERIODS_MRC_V dp,
1407: FA_BOOK_CONTROLS_MRC_V bc
1408: where bc.book_type_code = dp.book_type_code
1409: and fy.fiscal_year = dp.fiscal_year

Line 1720: fa_fiscal_year fy,

1716: l_fy_start_date,
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

Line 1885: fa_fiscal_year fy,

1881: l_fy_start_date,
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

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 2573: from fa_fiscal_year

2569: -- Find fiscal Year record
2570: cursor c_find_fy is
2571: select start_date
2572: , end_date
2573: from fa_fiscal_year
2574: where fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2575: and fiscal_year = p_fiscal_year;
2576:
2577:

Line 2583: FA_FISCAL_YEAR FY,

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

Line 2598: FA_FISCAL_YEAR FY,

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

Line 3701: from FA_FISCAL_YEAR fy,

3697: -- Query end date of period
3698: cursor C_GET_DATE is
3699: select fy.start_date fy_start_date,
3700: dp.calendar_period_close_date cp_end_date
3701: from FA_FISCAL_YEAR fy,
3702: FA_DEPRN_PERIODS dp,
3703: FA_BOOK_CONTROLS bc
3704: where bc.book_type_code = dp.book_type_code
3705: and fy.fiscal_year = dp.fiscal_year

Line 3713: from FA_FISCAL_YEAR fy,

3709:
3710: cursor C_GET_DATE_M is
3711: select fy.start_date fy_start_date,
3712: dp.calendar_period_close_date cp_end_date
3713: from FA_FISCAL_YEAR fy,
3714: FA_DEPRN_PERIODS_MRC_V dp,
3715: FA_BOOK_CONTROLS_MRC_V bc
3716: where bc.book_type_code = dp.book_type_code
3717: and fy.fiscal_year = dp.fiscal_year

Line 3969: FA_FISCAL_YEAR FY,

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

Line 3985: FA_FISCAL_YEAR FY,

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