APPS.HZ_MAP_PARTY_PUB dependencies on HZ_PHONE_COUNTRY_CODES

Line 399: -- Phone_country_code should be a valid value in HZ_PHONE_COUNTRY_CODES.

395: CLOSE c_currency_field;
396: END IF;
397:
398: /*--------------------------------------------------------------------*/
399: -- Phone_country_code should be a valid value in HZ_PHONE_COUNTRY_CODES.
400: --
401: -- Set to NULL otherwise.
402: /*--------------------------------------------------------------------*/
403:

Line 408: FROM HZ_PHONE_COUNTRY_CODES

404: BEGIN
405: IF p_interface_rec.phone_country_code IS NOT NULL THEN
406: SELECT '1'
407: INTO l_temp_cur_var
408: FROM HZ_PHONE_COUNTRY_CODES
409: WHERE phone_country_code = p_interface_rec.phone_country_code AND
410: ROWNUM = 1;
411: END IF;
412: EXCEPTION