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_HUB_CALENDAR dependencies on MSC_PERIOD_START_DATES

Line 47: from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd

43: return x_date;
44: elsif (p_bkt_type=3) then
45:
46: select min(mcd.calendar_date) into x_date
47: from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd
48: where mc.calendar_code = p_calendar_code
49: and mc.sr_instance_id = p_sr_instance_id
50: and mc.calendar_code = mcd.calendar_code
51: and mc.sr_instance_id = mcd.sr_instance_id

Line 152: from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd

148: return x_date;
149: elsif (p_bkt_type=3) then
150:
151: select max(mcd.calendar_date) into x_date
152: from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd
153: where mc.calendar_code = l_calendar_code
154: and mc.sr_instance_id = p_sr_instance_id
155: and mc.calendar_code = mcd.calendar_code
156: and mc.sr_instance_id = mcd.sr_instance_id

Line 223: from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd

219: return x_date;
220: elsif (p_bkt_type=3) then
221:
222: select max(mcd.calendar_date) into x_date
223: from msc_calendar_dates mcd, msc_calendars mc,msc_period_start_dates mpsd
224: where mc.calendar_code = p_calendar_code
225: and mc.sr_instance_id = p_sr_instance_id
226: and mc.calendar_code = mcd.calendar_code
227: and mc.sr_instance_id = mcd.sr_instance_id