DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CAL_EXCEPTIONS_B

Line 257: ,jtf_cal_exceptions_b e

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
261: and e.end_date_time >= p_start