267: , jtf_task_statuses_tl sl
268: , hz_party_sites ps
269: , hz_locations hl
270: , hz_parties pi
271: , fnd_timezones_b tz
272: WHERE a.task_id = p_task_id
273: AND resource_id = p_resource_id
274: AND resource_type_code = p_resource_type
275: AND tb.task_id = a.task_id
852: , jtf_task_statuses_tl sl
853: , hz_party_sites ps
854: , hz_locations hl
855: , hz_parties pi
856: , fnd_timezones_b tz
857: WHERE a.task_id = p_task_id
858: AND resource_id = p_resource_id
859: AND resource_type_code = p_resource_type
860: AND tb.task_id = a.task_id