APPS.PA_TIMELINE_PVT dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 250: FROM jtf_cal_resource_assign jtf_res,pa_resources pares

246: CURSOR cur_clndar IS
247: SELECT pares.resource_id resource_id,
248: trunc(start_date_time) start_date,
249: NVL(trunc(end_date_time), TO_DATE('12/31/4712','MM/DD/YYYY')) end_date
250: FROM jtf_cal_resource_assign jtf_res,pa_resources pares
251: WHERE jtf_res.resource_id = pares.jtf_resource_id
252: AND jtf_res.resource_type_code = 'RS_EMPLOYEE'
253: AND jtf_res.calendar_id = p_calendar_id
254: AND jtf_res.primary_calendar_flag = 'Y'