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_HP_UTIL dependencies on MSC_CALENDAR_DATES

Line 86: msc_calendar_dates md

82: b.bucket_type,
83: b.bucket_index
84: from
85: msc_plan_buckets b,
86: msc_calendar_dates md
87: where b.plan_id=p_plan_id
88: and b.curr_flag=1
89: and md.calendar_code=l_calendar_code
90: and md.exception_set_id=-1

Line 99: msc_calendar_dates md,

95: mw.next_date-1 week_end_date,
96: max(decode(md.seq_num, null, null, md.calendar_date)) week_last_work_date
97: from
98: msc_plan_buckets b,
99: msc_calendar_dates md,
100: msc_cal_week_start_dates mw
101: where b.plan_id=p_plan_id
102: and b.curr_flag=1
103: and md.calendar_date between b.bkt_start_date and b.bkt_end_date

Line 121: msc_calendar_dates md,

117: mp.next_date-1 period_end_date,
118: max(decode(md.seq_num, null, null, md.calendar_date)) period_last_work_date
119: from
120: msc_plan_buckets b,
121: msc_calendar_dates md,
122: msc_period_start_dates mp
123: where b.plan_id=p_plan_id
124: and b.curr_flag=1
125: and md.calendar_date between b.bkt_start_date and b.bkt_end_date