APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_PHONE_COUNTRY_CODES

Line 488: from hz_phone_country_codes

484: l_phone_rec.phone_country_code <> fnd_api.g_miss_char
485: THEN
486: BEGIN
487: select territory_code into l_country_code
488: from hz_phone_country_codes
489: where phone_country_code = l_phone_rec.phone_country_code
490: and rownum = 1;
491: EXCEPTION
492: WHEN NO_DATA_FOUND THEN

Line 1290: from hz_phone_country_codes

1286: l_phone_rec.phone_country_code <> fnd_api.g_miss_char
1287: THEN
1288: BEGIN
1289: select territory_code into l_country_code
1290: from hz_phone_country_codes
1291: where phone_country_code = l_phone_rec.phone_country_code
1292: and rownum = 1;
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN

Line 2352: FROM hz_phone_country_codes pcc, hz_phone_formats pf

2348: -- Query all the format styles along with other flags
2349: CURSOR c_formats IS
2350: SELECT pf.phone_format_style, pf.country_code_display_flag,
2351: pf.area_code_size, pcc.phone_country_code
2352: FROM hz_phone_country_codes pcc, hz_phone_formats pf
2353: WHERE pcc.territory_code = p_territory_code
2354: AND pcc.territory_code = pf.territory_code;
2355:
2356: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

Line 2358: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;

2354: AND pcc.territory_code = pf.territory_code;
2355:
2356: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
2357: l_area_code_size NUMBER;
2358: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;
2359: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;
2360: l_debug_prefix VARCHAR2(30) := '';
2361:
2362: BEGIN

Line 5715: FROM hz_phone_country_codes

5711: x_mobile_flag VARCHAR2(1) := NULL;
5712:
5713: CURSOR c_territory(p_country_code VARCHAR2) IS
5714: SELECT territory_code
5715: FROM hz_phone_country_codes
5716: WHERE phone_country_code = p_country_code;
5717:
5718: l_debug_prefix VARCHAR2(30) := '';
5719: