DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CALENDARS_B

Line 378: jtf_calendars_b b

374: --
375: cursor c_in_valid_cal_dates(p_start date, p_end date, p_res_id NUMBER, p_res_type VARCHAR2) is
376: select a.calendar_id, a.start_date_time, a.end_date_time,b.start_date_active, b.end_date_active
377: from jtf_cal_resource_assign a,
378: jtf_calendars_b b
379: where a.resource_id = p_res_id
380: and a.resource_type_code = p_res_type
381: and a.calendar_id = b.calendar_id
382: and a.primary_calendar_flag = 'Y'