DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CALENDARS_B

Line 321: jtf_calendars_b b

317: --
318: cursor c_in_valid_cal_dates(p_start date, p_end date, p_res_id NUMBER, p_res_type VARCHAR2) is
319: select a.calendar_id, a.start_date_time, a.end_date_time,b.start_date_active, b.end_date_active
320: from jtf_cal_resource_assign a,
321: jtf_calendars_b b
322: where a.resource_id = p_res_id
323: and a.resource_type_code = p_res_type
324: and a.calendar_id = b.calendar_id
325: and a.primary_calendar_flag = 'Y'