APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_CALENDARS_VL

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

1096: l_left_days number;
1097: l_calendar_id number;
1098: l_shift_id number;
1099:
1100: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug # 2493461 varchar2(100)
1101: l_calendar_start_date date;
1102: l_exp_flg varchar2(1) := 'N';
1103: l_start_date_time date;
1104:

Line 1176: jtf_calendars_vl b

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

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

1679: l_left_days number;
1680: l_calendar_id number;
1681: l_shift_id number;
1682:
1683: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug 2493461 varchar2(100);
1684: l_calendar_start_date date;
1685: l_exp_flg varchar2(1) := 'N';
1686: l_start_date_time date;
1687:

Line 1773: jtf_calendars_vl b

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

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

2515: j INTEGER := 0;
2516: l_shift_id NUMBER;
2517: l_unit_of_time_value NUMBER;
2518: l_calendar_id NUMBER;
2519: l_calendar_name jtf_calendars_vl.calendar_name%TYPE; -- bug 2493461 VARCHAR2(240)
2520: l_calendar_start_date DATE;
2521: l_shifts_total_duration NUMBER;
2522: l_left_days NUMBER;
2523: l_shift_date DATE;

Line 2595: jtf_calendars_vl b

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

Line 3046: from jtf_calendars_vl a

3042: BEGIN
3043:
3044: select 1
3045: into v_valid_cal
3046: from jtf_calendars_vl a
3047: where calendar_id = P_Calendar_Id
3048: -- Commented for bug 3891896 by ABRAINA
3049: -- 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'));
3050: and P_shift_date between trunc(a.start_date_active) and nvl(trunc(a.end_date_active),P_shift_date);