DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on HZ_LOCATIONS

Line 91: , hz_locations l

87: , l.postal_code
88: , fnd.territory_short_name country
89: , l.country country_code
90: FROM jtf_tasks_b t
91: , hz_locations l
92: , fnd_territories_vl fnd
93: WHERE t.task_id = p_task_id
94: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id)
95: AND fnd.territory_code = l.country;

Line 255: , hz_locations loc

251: FUNCTION get_timezone(p_address_id IN NUMBER) RETURN NUMBER IS
252: CURSOR c_timezone IS
253: SELECT loc.timezone_id
254: FROM hz_party_sites par
255: , hz_locations loc
256: WHERE par.party_site_id = p_address_id
257: AND par.location_id = loc.location_id;
258:
259: l_timezone c_timezone%ROWTYPE;