APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CALENDARS_VL

Line 1167: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)

1163: l_left_days number;
1164: l_calendar_id number;
1165: l_shift_id number;
1166:
1167: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)
1168: l_calendar_start_date date;
1169: l_exp_flg varchar2(1) := 'N';
1170: l_start_date_time date;
1171:

Line 1243: jtf_calendars_vl b

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
1247: and a.primary_calendar_flag = 'Y'

Line 1750: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug 2493461 varchar2(100);

1746: l_left_days number;
1747: l_calendar_id number;
1748: l_shift_id number;
1749:
1750: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug 2493461 varchar2(100);
1751: l_calendar_start_date date;
1752: l_exp_flg varchar2(1) := 'N';
1753: l_start_date_time date;
1754:

Line 1840: jtf_calendars_vl b

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
1844: and a.primary_calendar_flag = 'Y'

Line 2589: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug 2493461 VARCHAR2(240)

2585: j INTEGER := 0;
2586: l_shift_id NUMBER;
2587: l_unit_of_time_value NUMBER;
2588: l_calendar_id NUMBER;
2589: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug 2493461 VARCHAR2(240)
2590: l_calendar_start_date DATE;
2591: l_shifts_total_duration NUMBER;
2592: l_left_days NUMBER;
2593: l_shift_date DATE;

Line 2665: jtf_calendars_vl b

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
2669: and a.primary_calendar_flag = 'Y'

Line 3129: from jtf_calendars_vl a

3125: BEGIN
3126:
3127: select 1
3128: into v_valid_cal
3129: from jtf_calendars_vl a
3130: where calendar_id = P_Calendar_Id
3131: -- Commented for bug 3891896 by ABRAINA
3132: -- and P_shift_date between trunc(a.start_date_active) and nvl(trunc(a.end_date_active),to_date(get_g_miss_date,'DD/MM/RRRR'));
3133: and P_shift_date between trunc(a.start_date_active) and nvl(trunc(a.end_date_active),P_shift_date);