APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 320: from jtf_cal_resource_assign a,

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

Line 1175: from jtf_cal_resource_assign a,

1171: --
1172: begin --(1)
1173: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1174: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1175: from jtf_cal_resource_assign a,
1176: jtf_calendars_vl b
1177: where a.resource_id = p_resource_id
1178: and a.resource_type_code = p_resource_type
1179: and a.calendar_id = b.calendar_id

Line 1772: from jtf_cal_resource_assign a,

1768: --
1769: begin --(1)
1770: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1771: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1772: from jtf_cal_resource_assign a,
1773: jtf_calendars_vl b
1774: where a.resource_id = p_resource_id
1775: and a.resource_type_code = p_resource_type
1776: and a.calendar_id = b.calendar_id

Line 2594: from jtf_cal_resource_assign a,

2590: l_shift.delete;
2591: begin --(1)
2592: select a.calendar_id,b.calendar_name,b.start_date_active
2593: into l_calendar_id,l_calendar_name,l_calendar_start_date
2594: from jtf_cal_resource_assign a,
2595: jtf_calendars_vl b
2596: where a.resource_id = p_resource_id
2597: and a.resource_type_code = p_resource_type
2598: and a.calendar_id = b.calendar_id