APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 377: from jtf_cal_resource_assign a,

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

Line 1242: from jtf_cal_resource_assign a,

1238: --
1239: begin --(1)
1240: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1241: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1242: from jtf_cal_resource_assign a,
1243: jtf_calendars_vl b
1244: where a.resource_id = p_resource_id
1245: and a.resource_type_code = p_resource_type
1246: and a.calendar_id = b.calendar_id

Line 1839: from jtf_cal_resource_assign a,

1835: --
1836: begin --(1)
1837: select a.calendar_id,b.calendar_name,b.start_date_active,a.start_date_time
1838: into l_calendar_id,l_calendar_name,l_calendar_start_date,l_start_date_time
1839: from jtf_cal_resource_assign a,
1840: jtf_calendars_vl b
1841: where a.resource_id = p_resource_id
1842: and a.resource_type_code = p_resource_type
1843: and a.calendar_id = b.calendar_id

Line 2664: from jtf_cal_resource_assign a,

2660: l_shift.delete;
2661: begin --(1)
2662: select a.calendar_id,b.calendar_name,b.start_date_active
2663: into l_calendar_id,l_calendar_name,l_calendar_start_date
2664: from jtf_cal_resource_assign a,
2665: jtf_calendars_vl b
2666: where a.resource_id = p_resource_id
2667: and a.resource_type_code = p_resource_type
2668: and a.calendar_id = b.calendar_id