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 356: fa_calendar_periods fcp

352:
353: CURSOR fiscal_period_cur (l_book_type_code IN VARCHAR) IS
354: SELECT start_date
355: FROM fa_book_controls fbc,
356: fa_calendar_periods fcp
357: WHERE fbc.book_type_code = l_book_type_code
358: AND fcp.calendar_type = fbc.deprn_calendar
359: AND trunc(l_transaction_date) BETWEEN fcp.start_date AND fcp.end_date;
360:

Line 1784: FROM FA_CALENDAR_PERIODS FAP,

1780: and bc.book_type_code = c_book_type_code;
1781:
1782: CURSOR c_dep_date (c_calendar_type in varchar, c_book_type_code IN varchar, c_period_name in varchar) IS
1783: SELECT END_DATE
1784: FROM FA_CALENDAR_PERIODS FAP,
1785: fa_book_controls FAC
1786: WHERE FAP.calendAr_type=c_calendar_type
1787: AND FAC.BOOk_TYPE_CODE =c_book_type_code
1788: AND FAP.PERIOD_NAME=c_period_name;

Line 2484: fa_calendar_periods fcp

2480:
2481: SELECT fcp.period_name
2482: INTO l_period_name
2483: FROM fa_book_controls fbc,
2484: fa_calendar_periods fcp
2485: WHERE fbc.book_type_code = p_book_type_code
2486: AND fcp.calendar_type = fbc.deprn_calendar
2487: AND p_dpis BETWEEN fcp.start_date AND fcp.end_date;
2488: