APPS.JTF_CALENDAR_PUB dependencies on JTF_CALENDARS_B

Line 471: jtf_calendars_b b

467: -- get the primary calendar for a resource on the given date
468: select a.calendar_id,b.start_date_active
469: into l_calendar_id,l_calendar_start_date
470: from jtf_cal_resource_assign a,
471: jtf_calendars_b b
472: where a.resource_id = p_resource_id
473: and a.resource_type_code = p_resource_type
474: and a.calendar_id = b.calendar_id
475: and a.primary_calendar_flag = 'Y'

Line 2554: from jtf_calendars_b a

2550: BEGIN
2551:
2552: select 1
2553: into v_valid_cal
2554: from jtf_calendars_b a
2555: where calendar_id = P_Calendar_Id
2556: -- Commented for bug 3891896 by ABRAINA
2557: -- 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'));
2558: and P_shift_date between trunc(a.start_date_active) and nvl(trunc(a.end_date_active),P_shift_date);