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

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

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

129:
130: elsif (p_bkt_type = 2) then
131:
132: select max(mcd.calendar_date) into x_date
133: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
134: where mc.calendar_code = l_calendar_code
135: and mc.sr_instance_id = p_sr_instance_id
136: and mc.calendar_code = mcd.calendar_code
137: 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 191: from msc_calendar_dates mcd,msc_calendars mc

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

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

201:
202: elsif (p_bkt_type = 2) then
203:
204: select max(mcd.calendar_date) into x_date
205: from msc_calendar_dates mcd, msc_calendars mc,msc_cal_week_start_dates mcwsd
206: where mc.calendar_code = p_calendar_code
207: and mc.sr_instance_id = p_sr_instance_id
208: and mc.calendar_code = mcd.calendar_code
209: 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

Line 343: from msc_calendar_dates mcd,msc_calendars mc

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