APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_LOCATIONS

Line 514: FROM hz_locations

510: c_customer_phone_id NUMBER := p_service_request_rec.customer_phone_id;
511: -- List of Cursors used
512: CURSOR c_inc_address(p_incident_location_id NUMBER) IS
513: SELECT country,province,state,city,postal_code,county
514: FROM hz_locations
515: WHERE location_id = p_incident_location_id;
516:
517: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
518: SELECT location_id FROM hz_party_sites

Line 936: FROM hz_locations

932: c_customer_phone_id NUMBER := p_service_request_rec.customer_phone_id;
933:
934: CURSOR c_inc_address(p_incident_location_id NUMBER) IS
935: SELECT country,province,state,city,postal_code,county
936: FROM hz_locations
937: WHERE location_id = p_incident_location_id;
938:
939: CURSOR c_inc_party_site_address(p_party_site_id NUMBER) IS
940: SELECT location_id FROM hz_party_sites