APPS.HZ_POPULATE_TIMEZONE_PKG dependencies on HZ_PHONE_COUNTRY_CODES

Line 112: from hz_phone_country_codes

108: l_api_version CONSTANT NUMBER := 1.0;
109:
110: cursor get_tz_by_pcc_csr is
111: select timezone_id
112: from hz_phone_country_codes
113: where phone_country_code = p_phone_country_code;
114:
115: cursor get_tz_by_pcc_cc_csr is
116: select timezone_id

Line 117: from hz_phone_country_codes

113: where phone_country_code = p_phone_country_code;
114:
115: cursor get_tz_by_pcc_cc_csr is
116: select timezone_id
117: from hz_phone_country_codes
118: where territory_code = p_country_code
119: and phone_country_code = p_phone_country_code;
120:
121: cursor get_country_tz_count_csr is

Line 123: from hz_phone_country_codes

119: and phone_country_code = p_phone_country_code;
120:
121: cursor get_country_tz_count_csr is
122: select count(*)
123: from hz_phone_country_codes
124: where phone_country_code = p_phone_country_code;
125:
126: cursor get_area_code_tzone_csr is
127: select timezone_id