APPS.JTF_CALENDAR_PUB dependencies on JTF_CALENDARS_B

Line 513: jtf_calendars_b b

509: -- get the primary calendar for a resource on the given date
510: select a.calendar_id,b.start_date_active
511: into l_calendar_id,l_calendar_start_date
512: from jtf_cal_resource_assign a,
513: jtf_calendars_b b
514: where a.resource_id = p_resource_id
515: and a.resource_type_code = p_resource_type
516: and a.calendar_id = b.calendar_id
517: and a.primary_calendar_flag = 'Y'

Line 2617: from jtf_calendars_b a

2613: BEGIN
2614:
2615: select 1
2616: into v_valid_cal
2617: from jtf_calendars_b a
2618: where calendar_id = P_Calendar_Id
2619: -- Commented for bug 3891896 by ABRAINA
2620: -- 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'));
2621: and P_shift_date between trunc(a.start_date_active) and nvl(trunc(a.end_date_active),P_shift_date);