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_CALENDAR_PERIODS

Line 7: g_period_num1 fa_calendar_periods.period_num%TYPE;

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;
11: g_num_per_fy fa_calendar_types.number_per_fiscal_year%TYPE;

Line 8: g_period_num2 fa_calendar_periods.period_num%TYPE;

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;
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

Line 9: g_end_date1 fa_calendar_periods.end_date%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;
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

Line 10: g_end_date2 fa_calendar_periods.end_date%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;
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

Line 1919: FROM fa_calendar_periods cp,

1915: l_cp_end_date,
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,

Line 2092: FROM fa_calendar_periods cp,

2088: l_cp_end_date,
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,

Line 2732: FA_CALENDAR_PERIODS CP

2728: from FA_BOOKS BK1,
2729: FA_BOOKS BK2,
2730: FA_BOOKS BK3,
2731: FA_TRANSACTION_HEADERS TH,
2732: FA_CALENDAR_PERIODS CP
2733: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2734: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2735: and BK2.BOOK_TYPE_CODE = p_book_type_code
2736: and TH.TRANSACTION_DATE_ENTERED <= CP.END_DATE

Line 2752: FA_CALENDAR_PERIODS CP

2748: and BK3.TRANSACTION_HEADER_ID_IN=
2749: (select max(BK.TRANSACTION_HEADER_ID_IN)
2750: from FA_BOOKS BK,
2751: FA_TRANSACTION_HEADERS TH,
2752: FA_CALENDAR_PERIODS CP
2753: where BK.ASSET_ID= p_asset_id
2754: and BK.BOOK_TYPE_CODE = p_book_type_code
2755: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID
2756: and BK.ASSET_ID= TH.ASSET_ID

Line 2779: FA_CALENDAR_PERIODS CP

2775: from FA_MC_BOOKS BK1,
2776: FA_MC_BOOKS BK2,
2777: FA_MC_BOOKS BK3,
2778: FA_TRANSACTION_HEADERS TH,
2779: FA_CALENDAR_PERIODS CP
2780: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2781: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2782: and BK2.BOOK_TYPE_CODE = p_book_type_code
2783: and BK1.set_of_books_id = p_set_of_books_id

Line 2803: FA_CALENDAR_PERIODS CP,

2799: and BK3.TRANSACTION_HEADER_ID_IN=
2800: (select max(BK.TRANSACTION_HEADER_ID_IN)
2801: from FA_MC_BOOKS BK,
2802: FA_TRANSACTION_HEADERS TH,
2803: FA_CALENDAR_PERIODS CP,
2804: FA_MC_BOOK_CONTROLS BC
2805: where BK.ASSET_ID= p_asset_id
2806: and BK.BOOK_TYPE_CODE = p_book_type_code
2807: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID

Line 2825: from FA_CALENDAR_PERIODS CP,

2821: -- bug 8256548 END
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

Line 2840: from FA_CALENDAR_PERIODS CP,

2836: and CP.PERIOD_NUM = p_period_num;
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

Line 4397: from FA_CALENDAR_PERIODS CP,

4393: -- Get period end date of transaction
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

Line 4413: from FA_CALENDAR_PERIODS CP,

4409:
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