381: hz_party_sites ps,
382: hz_locations hl,
383: hz_parties pi,
384: jtf_task_assignments jtb,
385: jtf_task_priorities_vl jtp
386: WHERE esc_t.task_id = r.task_id
387: AND esc_t.task_type_id = 22
388: AND s.task_status_id = jtb.assignment_status_id
389: AND r.reference_code = 'ESC'
410: hz_party_sites ps,
411: hz_locations hl,
412: hz_parties pi,
413: jtf_task_assignments jtb,
414: jtf_task_priorities_vl jtp
415: WHERE jtb.task_id = b.task_id
416: AND s.task_status_id = jtb.assignment_status_id
417: AND ps.party_site_id(+) = b.address_id
418: AND hl.location_id(+) = ps.location_id