APPS.PA_RESOURCE_UTILS dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 3126: jtf_cal_resource_assign jcra

3122:
3123: SELECT jcra.calendar_id
3124: INTO l_calendar_id
3125: FROM pa_resources par,
3126: jtf_cal_resource_assign jcra
3127: WHERE par.jtf_resource_id = jcra.resource_id
3128: AND par.resource_id = p_resource_id
3129: AND p_wk_date between jcra.start_date_time and nvl(jcra.end_date_time,to_date('31-12-4712', 'DD-MM-YYYY'));
3130: