APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CAL_EXCEPTION_ASSIGN

Line 256: from jtf_cal_exception_assign a

252: select e.start_date_time start_except,
253: e.end_date_time end_except,
254: nvl(a.start_date_active,p_start) start_assign,
255: nvl(a.end_date_active,p_end) end_assign
256: from jtf_cal_exception_assign a
257: ,jtf_cal_exceptions_b e
258: where a.calendar_id = p_calendar_id
259: and a.exception_id = e.exception_id
260: and e.start_date_time <= p_end

Line 1061: from jtf_cal_exception_assign a

1057:
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

Line 1643: from jtf_cal_exception_assign a

1639: is
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

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)