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.JTF_CALENDAR_PUB dependencies on JTF_CAL_EXCEPTIONS_VL

Line 363: ,jtf_cal_exceptions_vl e

359: e.end_date_time)
360: ),
361: e.end_date_time) end_except
362: from jtf_cal_exception_assign a
363: ,jtf_cal_exceptions_vl e
364: where a.calendar_id = p_calendar_id
365: and a.exception_id = e.exception_id
366: -- validate exception assignment
367: and ( p_day >= trunc(Decode(p_tz_enabled,'Y',

Line 933: , jtf_cal_exceptions_vl e

929: is
930: select e.start_date_time start_except
931: , e.end_date_time end_except
932: from jtf_cal_exception_assign a
933: , jtf_cal_exceptions_vl e
934: where a.calendar_id = p_calendar_id
935: and a.exception_id = e.exception_id
936: -- validate exception assignment
937: and ( p_day >= trunc(a.start_date_active)

Line 1436: , jtf_cal_exceptions_vl e

1432: is
1433: select e.start_date_time start_except
1434: , e.end_date_time end_except
1435: from jtf_cal_exception_assign a
1436: , jtf_cal_exceptions_vl e
1437: where a.calendar_id = p_calendar_id
1438: and a.exception_id = e.exception_id
1439: -- validate exception assignment
1440: and ( p_day >= trunc(a.start_date_active)

Line 2058: from jtf_cal_exceptions_vl a, jtf_cal_exception_assign b

2054: --
2055: cursor excp_hrs(p_calendar_id NUMBER, p_req_date DATE) is
2056: select to_char(a.start_date_time,'HH24.MI') excp_start_time,
2057: to_char(a.end_date_time,'HH24.MI') excp_end_time
2058: from jtf_cal_exceptions_vl a, jtf_cal_exception_assign b
2059: where trunc(a.start_date_time) = p_req_date
2060: and a.exception_id = b.exception_id
2061: and b.calendar_id = p_calendar_id;
2062: --