APPS.CS_SR_TASK_AUTOASSIGN_PKG dependencies on HZ_PARTY_SITES

Line 170: -- for location_type, HZ_PARTY_SITES

166: FROM cs_incidents_all_b
167: WHERE incident_id = p_incident_id;
168:
169: -- For 11.5.10+ Need to get the location_id from party sites
170: -- for location_type, HZ_PARTY_SITES
171: CURSOR c_inc_address(p_incident_location_id NUMBER) IS
172: SELECT country,province,state,city,postal_code,county
173: FROM hz_locations
174: WHERE location_id = p_incident_location_id;

Line 177: SELECT location_id FROM hz_party_sites

173: FROM hz_locations
174: WHERE location_id = p_incident_location_id;
175:
176: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
177: SELECT location_id FROM hz_party_sites
178: WHERE party_site_id = p_party_site_id;
179:
180: -- Added the following cursors for ER# 3811871.
181: CURSOR c_inv_comp_id(p_component_id NUMBER) IS