DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on HZ_LOCATIONS

Line 163: , hz_locations lo

159: , ib.cust_pref_lang_code
160: FROM jtf_tasks_b tb
161: , cs_incidents_all_b ib
162: , cs_incidents_all_tl it
163: , hz_locations lo
164: , hz_parties pa
165: WHERE tb.task_id = p_task_id
166: AND tb.source_object_type_code = 'SR'
167: AND tb.source_object_id = ib.incident_id

Line 917: FROM jtf_tasks_b t, hz_locations l

913: l_distance NUMBER;
914:
915: CURSOR c_task_geometry IS
916: SELECT l.geometry
917: FROM jtf_tasks_b t, hz_locations l
918: WHERE t.task_id = p_task_id
919: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
920:
921: CURSOR c_sorted_resources IS