APPS.PA_CALENDAR_UTILS dependencies on JTF_CALENDARS_B

Line 201: FROM JTF_CALENDARS_B

197: -- Taking the active date of the calendar if the ending date of the calendar is not
198: -- defined then taking the specified date
199: SELECT start_date_active ,NVL(end_date_active,TO_DATE('01/01/2050','DD/MM/YYYY'))
200: INTO l_t_start_date,l_t_end_date
201: FROM JTF_CALENDARS_B
202: WHERE calendar_id = p_calendar_id;
203:
204: -- if only one shift is assign to the calendar
205: IF (p_cal_record_tab.count = 1 ) THEN

Line 610: FROM jtf_calendars_b -- 4370086: FROM jtf_calendars_vl

606: IF (p_check_id_flag = 'Y') THEN
607: -- Validate ID
608: SELECT calendar_id
609: INTO x_calendar_id
610: FROM jtf_calendars_b -- 4370086: FROM jtf_calendars_vl
611: WHERE calendar_id = p_calendar_id;
612: ELSIF (p_check_id_flag = 'N') THEN
613: -- No ID validation necessary
614: x_calendar_id := p_calendar_id;