APPS.HZ_TIMEZONE_PUB dependencies on HZ_TIMEZONE_MAPPING

Line 84: FROM HZ_TIMEZONE_MAPPING

80: -- and a match on that postal code and country are found, that is the correct time zone (without regard
81: -- to the city or state on the mapping row or the city or state passed in)
82: SELECT timezone_id
83: INTO x_timezone_id
84: FROM HZ_TIMEZONE_MAPPING
85: WHERE postal_code = p_postal_code
86: AND country = p_country;
87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: -- if no postal code direct match is found, then start walking the geographic hierarchy.

Line 99: FROM HZ_TIMEZONE_MAPPING

95: IF (p_state is null) THEN --compare all, no state
96: BEGIN
97: SELECT timezone_id
98: INTO x_timezone_id
99: FROM HZ_TIMEZONE_MAPPING
100: WHERE postal_code = p_postal_code
101: AND upper(city) = upper(p_city)
102: AND state is null
103: AND country = p_country;

Line 108: FROM HZ_TIMEZONE_MAPPING

104: EXCEPTION WHEN NO_DATA_FOUND THEN --compare city, no state
105: BEGIN
106: SELECT timezone_id
107: INTO x_timezone_id
108: FROM HZ_TIMEZONE_MAPPING
109: WHERE postal_code is null
110: AND upper(city) = upper(p_city)
111: AND state is null
112: AND country = p_country;

Line 117: FROM HZ_TIMEZONE_MAPPING

113: EXCEPTION WHEN NO_DATA_FOUND THEN --compare country, no state
114: BEGIN
115: SELECT timezone_id
116: INTO x_timezone_id
117: FROM HZ_TIMEZONE_MAPPING
118: WHERE postal_code is null
119: AND city is null
120: AND state is null
121: AND country = p_country;

Line 153: FROM HZ_TIMEZONE_MAPPING

149:
150: BEGIN -- compare all
151: SELECT timezone_id
152: INTO x_timezone_id
153: FROM HZ_TIMEZONE_MAPPING
154: WHERE postal_code = p_postal_code
155: AND upper(city) = upper(p_city)
156: AND state = p_state
157: AND country = p_country;

Line 162: FROM HZ_TIMEZONE_MAPPING

158: EXCEPTION WHEN NO_DATA_FOUND THEN --compare city, state, country
159: BEGIN
160: SELECT timezone_id
161: INTO x_timezone_id
162: FROM HZ_TIMEZONE_MAPPING
163: WHERE postal_code is null
164: AND upper(city) = upper(p_city)
165: AND state = p_state
166: AND country = p_country;

Line 171: FROM HZ_TIMEZONE_MAPPING

167: EXCEPTION WHEN NO_DATA_FOUND THEN --compare state, country
168: BEGIN
169: SELECT timezone_id
170: INTO x_timezone_id
171: FROM HZ_TIMEZONE_MAPPING
172: WHERE postal_code is null
173: AND city is null
174: AND state = p_state
175: AND country = p_country;

Line 180: FROM HZ_TIMEZONE_MAPPING

176: EXCEPTION WHEN NO_DATA_FOUND THEN --compare country
177: BEGIN
178: SELECT timezone_id
179: INTO x_timezone_id
180: FROM HZ_TIMEZONE_MAPPING
181: WHERE postal_code is null
182: AND city is null
183: AND state is null
184: AND country = p_country;