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 8: g_period_num1 fa_calendar_periods.period_num%TYPE;

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

Line 9: g_period_num2 fa_calendar_periods.period_num%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;
12: g_num_per_fy fa_calendar_types.number_per_fiscal_year%TYPE;
13:

Line 10: g_end_date1 fa_calendar_periods.end_date%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;
12: g_num_per_fy fa_calendar_types.number_per_fiscal_year%TYPE;
13:
14: FUNCTION faxcdb(

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

Line 1719: FROM fa_calendar_periods cp,

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

Line 1884: FROM fa_calendar_periods cp,

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

Line 2486: FA_CALENDAR_PERIODS CP

2482: from FA_BOOKS BK1,
2483: FA_BOOKS BK2,
2484: FA_BOOKS BK3,
2485: FA_TRANSACTION_HEADERS TH,
2486: FA_CALENDAR_PERIODS CP
2487: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2488: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2489: and BK2.BOOK_TYPE_CODE = p_book_type_code
2490: and TH.TRANSACTION_DATE_ENTERED <= CP.END_DATE

Line 2506: FA_CALENDAR_PERIODS CP

2502: and BK3.TRANSACTION_HEADER_ID_IN=
2503: (select max(BK.TRANSACTION_HEADER_ID_IN)
2504: from FA_BOOKS BK,
2505: FA_TRANSACTION_HEADERS TH,
2506: FA_CALENDAR_PERIODS CP
2507: where BK.ASSET_ID= p_asset_id
2508: and BK.BOOK_TYPE_CODE = p_book_type_code
2509: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID
2510: and BK.ASSET_ID= TH.ASSET_ID

Line 2533: FA_CALENDAR_PERIODS CP

2529: from FA_BOOKS_MRC_V BK1,
2530: FA_BOOKS_MRC_V BK2,
2531: FA_BOOKS_MRC_V BK3,
2532: FA_TRANSACTION_HEADERS TH,
2533: FA_CALENDAR_PERIODS CP
2534: where TH.TRANSACTION_HEADER_ID = BK1.TRANSACTION_HEADER_ID_OUT(+)
2535: and TH.TRANSACTION_HEADER_ID = BK2.TRANSACTION_HEADER_ID_IN
2536: and BK2.BOOK_TYPE_CODE = p_book_type_code
2537: and TH.TRANSACTION_DATE_ENTERED <= CP.END_DATE

Line 2553: FA_CALENDAR_PERIODS CP,

2549: and BK3.TRANSACTION_HEADER_ID_IN=
2550: (select max(BK.TRANSACTION_HEADER_ID_IN)
2551: from FA_BOOKS_MRC_V BK,
2552: FA_TRANSACTION_HEADERS TH,
2553: FA_CALENDAR_PERIODS CP,
2554: FA_BOOK_CONTROLS_MRC_V BC
2555: where BK.ASSET_ID= p_asset_id
2556: and BK.BOOK_TYPE_CODE = p_book_type_code
2557: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID

Line 2581: from FA_CALENDAR_PERIODS CP,

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

Line 2596: from FA_CALENDAR_PERIODS CP,

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

Line 3967: from FA_CALENDAR_PERIODS CP,

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

Line 3983: from FA_CALENDAR_PERIODS CP,

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