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_24HR dependencies on JTF_CAL_EXCEPTIONS_VL

Line 1062: ,jtf_cal_exceptions_vl e

1058: cursor c_cal_except ( p_calendar_id number, p_day date ) is
1059: select e.start_date_time start_except
1060: ,e.end_date_time end_except
1061: from jtf_cal_exception_assign a
1062: ,jtf_cal_exceptions_vl e
1063: where a.calendar_id = p_calendar_id
1064: and a.exception_id = e.exception_id
1065: -- validate exception assignment
1066: and (

Line 1644: , jtf_cal_exceptions_vl e

1640: --changed cur .. sudarsana for 24 hr shifts
1641: select e.start_date_time start_except
1642: , e.end_date_time end_except
1643: from jtf_cal_exception_assign a
1644: , jtf_cal_exceptions_vl e
1645: where a.calendar_id = p_calendar_id
1646: and a.exception_id = e.exception_id
1647: -- validate exception assignment
1648: and (

Line 2423: from jtf_cal_exceptions_vl e, jtf_cal_exception_assign a

2419: --
2420: cursor excp_hrs(p_calendar_id NUMBER, p_day DATE) is
2421: select e.start_date_time excp_start_time,
2422: e.end_date_time excp_end_time
2423: from jtf_cal_exceptions_vl e, jtf_cal_exception_assign a
2424: where a.calendar_id = p_calendar_id
2425: and a.exception_id = e.exception_id
2426: and (
2427: ( p_day >= trunc(a.start_date_active)