DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_PHONE_COUNTRY_CODES

Line 1022: l1_country_code hz_phone_country_codes.territory_code%type;

1018: WHERE location_id = (SELECT location_id
1019: FROM hz_party_sites
1020: WHERE party_site_id = p_site_id);
1021:
1022: l1_country_code hz_phone_country_codes.territory_code%type;
1023: c_phone_format RefCurType;
1024:
1025: BEGIN
1026:

Line 1067: from hz_phone_country_codes

1063: IF l_phone_number(i) IS NULL THEN
1064: IF l_country_code(i) IS NOT NULL THEN
1065: BEGIN
1066: select territory_code into l1_country_code
1067: from hz_phone_country_codes
1068: where phone_country_code = l_country_code(i)
1069: and rownum = 1;
1070: EXCEPTION
1071: WHEN NO_DATA_FOUND THEN