DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on HZ_LOCATIONS

Line 144: , hz_locations lo

140: , ib.contract_service_id
141: FROM jtf_tasks_b tb
142: , cs_incidents_all_b ib
143: , cs_incidents_all_tl it
144: , hz_locations lo
145: , hz_parties pa
146: WHERE tb.task_id = p_task_id
147: AND tb.source_object_type_code = 'SR'
148: AND tb.source_object_id = ib.incident_id

Line 753: FROM jtf_tasks_b t, hz_locations l

749: l_distance NUMBER;
750:
751: CURSOR c_task_geometry IS
752: SELECT l.geometry
753: FROM jtf_tasks_b t, hz_locations l
754: WHERE t.task_id = p_task_id
755: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
756:
757: CURSOR c_sorted_resources IS