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.CSE_ASSET_UTIL_PKG dependencies on FA_CALENDAR_PERIODS

Line 400: fa_calendar_periods fcp

396:
397: CURSOR fiscal_period_cur (l_book_type_code IN VARCHAR) IS
398: SELECT start_date
399: FROM fa_book_controls fbc,
400: fa_calendar_periods fcp
401: WHERE fbc.book_type_code = l_book_type_code
402: AND fcp.calendar_type = fbc.deprn_calendar
403: AND trunc(l_transaction_date) BETWEEN fcp.start_date AND fcp.end_date;
404:

Line 1974: FROM FA_CALENDAR_PERIODS FAP,

1970: and bc.book_type_code = c_book_type_code;
1971:
1972: CURSOR c_dep_date (c_calendar_type in varchar, c_book_type_code IN varchar, c_period_name in varchar) IS
1973: SELECT END_DATE
1974: FROM FA_CALENDAR_PERIODS FAP,
1975: fa_book_controls FAC
1976: WHERE FAP.calendAr_type=c_calendar_type
1977: AND FAC.BOOk_TYPE_CODE =c_book_type_code
1978: AND FAP.PERIOD_NAME=c_period_name;

Line 2748: fa_calendar_periods fcp

2744:
2745: SELECT fcp.period_name
2746: INTO l_period_name
2747: FROM fa_book_controls fbc,
2748: fa_calendar_periods fcp
2749: WHERE fbc.book_type_code = p_book_type_code
2750: AND fcp.calendar_type = fbc.deprn_calendar
2751: AND p_dpis BETWEEN fcp.start_date AND fcp.end_date;
2752: