APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_LOCATIONS

Line 502: FROM hz_locations

498: c_customer_phone_id NUMBER := p_service_request_rec.customer_phone_id;
499: -- List of Cursors used
500: CURSOR c_inc_address(p_incident_location_id NUMBER) IS
501: SELECT country,province,state,city,postal_code,county
502: FROM hz_locations
503: WHERE location_id = p_incident_location_id;
504:
505: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
506: SELECT location_id FROM hz_party_sites

Line 829: FROM hz_locations

825: c_customer_phone_id NUMBER := p_service_request_rec.customer_phone_id;
826:
827: CURSOR c_inc_address(p_incident_location_id NUMBER) IS
828: SELECT country,province,state,city,postal_code,county
829: FROM hz_locations
830: WHERE location_id = p_incident_location_id;
831:
832: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
833: SELECT location_id FROM hz_party_sites