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.MSC_X_HZ_PLAN dependencies on MSC_CALENDAR_DATES

Line 1264: FROM msc_calendar_dates day, msc_cal_week_start_dates week

1260: SELECT
1261: day.calendar_date
1262: BULK COLLECT INTO
1263: daily_bucket_dates
1264: FROM msc_calendar_dates day, msc_cal_week_start_dates week
1265: WHERE day.calendar_code = v_cal_code
1266: and day.exception_set_id = -1
1267: and day.calendar_date >= p_start_date
1268: and day.calendar_date < week.next_date

Line 1282: FROM msc_calendar_dates day, msc_period_start_dates month

1278: SELECT
1279: day.calendar_date
1280: BULK COLLECT INTO
1281: daily_bucket_dates
1282: FROM msc_calendar_dates day, msc_period_start_dates month
1283: WHERE day.calendar_code = v_cal_code
1284: and day.exception_set_id = -1
1285: and day.calendar_date >= p_start_date
1286: and day.calendar_date < month.next_date

Line 1300: FROM msc_calendar_dates

1296: SELECT
1297: calendar_date
1298: BULK COLLECT INTO
1299: daily_bucket_dates
1300: FROM msc_calendar_dates
1301: WHERE calendar_code = v_cal_code
1302: and exception_set_id = -1
1303: and calendar_date >= p_start_date
1304: and calendar_date < p_start_date + daily_bucket_count