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 1129: ,jtf_cal_exceptions_vl e

1125: cursor c_cal_except ( p_calendar_id number, p_day date ) is
1126: select e.start_date_time start_except
1127: ,e.end_date_time end_except
1128: from jtf_cal_exception_assign a
1129: ,jtf_cal_exceptions_vl e
1130: where a.calendar_id = p_calendar_id
1131: and a.exception_id = e.exception_id
1132: -- validate exception assignment
1133: and (

Line 1711: , jtf_cal_exceptions_vl e

1707: --changed cur .. sudarsana for 24 hr shifts
1708: select e.start_date_time start_except
1709: , e.end_date_time end_except
1710: from jtf_cal_exception_assign a
1711: , jtf_cal_exceptions_vl e
1712: where a.calendar_id = p_calendar_id
1713: and a.exception_id = e.exception_id
1714: -- validate exception assignment
1715: and (

Line 2493: from jtf_cal_exceptions_vl e, jtf_cal_exception_assign a

2489: --
2490: cursor excp_hrs(p_calendar_id NUMBER, p_day DATE) is
2491: select e.start_date_time excp_start_time,
2492: e.end_date_time excp_end_time
2493: from jtf_cal_exceptions_vl e, jtf_cal_exception_assign a
2494: where a.calendar_id = p_calendar_id
2495: and a.exception_id = e.exception_id
2496: and (
2497: ( p_day >= trunc(a.start_date_active)