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_CALENDAR_DATES

Line 15: from msc_calendar_dates mcd,msc_calendars mc

11: if (p_bkt_type =1 ) then
12: -- this is the day bucket
13: -- check whether this day is the working date
14: select mcd.calendar_date into x_date
15: from msc_calendar_dates mcd,msc_calendars mc
16: where mc.calendar_code = p_calendar_code
17: and mc.sr_instance_id = p_sr_instance_id
18: and mc.calendar_code=mcd.calendar_code
19: and mc.sr_instance_id=mcd.sr_instance_id

Line 29: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd

25:
26: elsif (p_bkt_type = 2) then
27:
28: select min(mcd.calendar_date) into x_date
29: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
30: where mc.calendar_code = p_calendar_code
31: and mc.sr_instance_id = p_sr_instance_id
32: and mc.calendar_code = mcd.calendar_code
33: and mc.sr_instance_id = mcd.sr_instance_id

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 118: from msc_calendar_dates mcd,msc_calendars mc

114: --- for daily bucket, it is the work day
115: --- engine sometime put s/d on day bucket even if
116: --- it is not working day
117: select mcd.calendar_date into x_date
118: from msc_calendar_dates mcd,msc_calendars mc
119: where mc.calendar_code = l_calendar_code
120: and mc.sr_instance_id = p_sr_instance_id
121: and mc.calendar_code=mcd.calendar_code
122: and mc.sr_instance_id=mcd.sr_instance_id

Line 132: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd

128:
129: elsif (p_bkt_type = 2) then
130:
131: select max(mcd.calendar_date) into x_date
132: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
133: where mc.calendar_code = l_calendar_code
134: and mc.sr_instance_id = p_sr_instance_id
135: and mc.calendar_code = mcd.calendar_code
136: and mc.sr_instance_id = mcd.sr_instance_id

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

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

Line 190: from msc_calendar_dates mcd,msc_calendars mc

186: if (p_bkt_type =1 ) then
187: -- this is the day bucket
188: -- check whether this day is the working date
189: select mcd.calendar_date into x_date
190: from msc_calendar_dates mcd,msc_calendars mc
191: where mc.calendar_code = p_calendar_code
192: and mc.sr_instance_id = p_sr_instance_id
193: and mc.calendar_code=mcd.calendar_code
194: and mc.sr_instance_id=mcd.sr_instance_id

Line 204: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd

200:
201: elsif (p_bkt_type = 2) then
202:
203: select max(mcd.calendar_date) into x_date
204: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
205: where mc.calendar_code = p_calendar_code
206: and mc.sr_instance_id = p_sr_instance_id
207: and mc.calendar_code = mcd.calendar_code
208: and mc.sr_instance_id = mcd.sr_instance_id

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

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

Line 341: from msc_calendar_dates mcd,msc_calendars mc

337:
338: if (p_bkt_type =1 ) then
339:
340: select max(mcd.calendar_date) into x_date
341: from msc_calendar_dates mcd,msc_calendars mc
342: where mc.calendar_code = l_calendar_code
343: and mc.sr_instance_id = p_sr_instance_id
344: and mc.calendar_code=mcd.calendar_code
345: and mc.sr_instance_id=mcd.sr_instance_id