DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on JTF_CAL_RESOURCE_ASSIGN

Line 3387: jtf_cal_resource_assign jcra

3383:
3384: SELECT jcra.calendar_id
3385: INTO l_calendar_id
3386: FROM pa_resources par,
3387: jtf_cal_resource_assign jcra
3388: WHERE par.jtf_resource_id = jcra.resource_id
3389: AND par.resource_id = p_resource_id
3390: AND p_wk_date between jcra.start_date_time and nvl(jcra.end_date_time,to_date('31-12-4712', 'DD-MM-YYYY'));
3391: