APPS.CSR_SCHEDULER_PVT dependencies on HZ_LOCATIONS

Line 97: , hz_locations l

93: , fnd.territory_short_name country
94: , l.country country_code
95: , l.geometry_status_code
96: FROM jtf_tasks_b t
97: , hz_locations l
98: , fnd_territories_vl fnd
99: WHERE t.task_id = p_task_id
100: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id)
101: AND fnd.territory_code = l.country;

Line 105: l_geo_status_code hz_locations.geometry_status_code%TYPE;

101: AND fnd.territory_code = l.country;
102:
103: l_address_info c_address_info%ROWTYPE;
104: l_locus_valid VARCHAR2(6);
105: l_geo_status_code hz_locations.geometry_status_code%TYPE;
106: BEGIN
107: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
108: RAISE fnd_api.g_exc_unexpected_error;
109: END IF;

Line 267: , hz_locations loc

263: FUNCTION get_timezone(p_address_id IN NUMBER) RETURN NUMBER IS
264: CURSOR c_timezone IS
265: SELECT loc.timezone_id
266: FROM hz_party_sites par
267: , hz_locations loc
268: WHERE par.party_site_id = p_address_id
269: AND par.location_id = loc.location_id;
270:
271: l_timezone c_timezone%ROWTYPE;