APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_PHONE_COUNTRY_CODES

Line 478: from hz_phone_country_codes

474: l_phone_rec.phone_country_code <> fnd_api.g_miss_char
475: THEN
476: BEGIN
477: select territory_code into l_country_code
478: from hz_phone_country_codes
479: where phone_country_code = l_phone_rec.phone_country_code
480: and rownum = 1;
481: EXCEPTION
482: WHEN NO_DATA_FOUND THEN

Line 1277: from hz_phone_country_codes

1273: l_phone_rec.phone_country_code <> fnd_api.g_miss_char
1274: THEN
1275: BEGIN
1276: select territory_code into l_country_code
1277: from hz_phone_country_codes
1278: where phone_country_code = l_phone_rec.phone_country_code
1279: and rownum = 1;
1280: EXCEPTION
1281: WHEN NO_DATA_FOUND THEN

Line 2199: FROM hz_phone_country_codes pcc, hz_phone_formats pf

2195: -- Query all the format styles along with other flags
2196: CURSOR c_formats IS
2197: SELECT pf.phone_format_style, pf.country_code_display_flag,
2198: pf.area_code_size, pcc.phone_country_code
2199: FROM hz_phone_country_codes pcc, hz_phone_formats pf
2200: WHERE pcc.territory_code = p_territory_code
2201: AND pcc.territory_code = pf.territory_code;
2202:
2203: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

Line 2205: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;

2201: AND pcc.territory_code = pf.territory_code;
2202:
2203: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
2204: l_area_code_size NUMBER;
2205: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;
2206: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;
2207: l_debug_prefix VARCHAR2(30) := '';
2208:
2209: BEGIN

Line 5559: FROM hz_phone_country_codes

5555: x_mobile_flag VARCHAR2(1) := NULL;
5556:
5557: CURSOR c_territory(p_country_code VARCHAR2) IS
5558: SELECT territory_code
5559: FROM hz_phone_country_codes
5560: WHERE phone_country_code = p_country_code;
5561:
5562: l_debug_prefix VARCHAR2(30) := '';
5563: