APPS.HZ_EMAIL_DOMAINS_V2PUB dependencies on AR_LOOKUPS

Line 673: SELECT 1 INTO tmp FROM AR_LOOKUPS WHERE

669: l_tok := HZ_DQM_SEARCH_UTIL.strtok(p_input_str,1,'.');
670: -- UK
671: WHILE l_tok IS NOT NULL LOOP
672: BEGIN
673: SELECT 1 INTO tmp FROM AR_LOOKUPS WHERE
674: lookup_type = 'HZ_DOMAIN_SUFFIX_LIST'
675: and lookup_code = l_leftover;
676:
677: x_first_seg := l_prev_tok;

Line 804: SELECT 1 INTO tmp FROM AR_LOOKUPS

800: -- dbms_output.put_line('after stripping @ full domain is' || tempstr);
801:
802: -- do the ISP check on the tempstr
803: BEGIN
804: SELECT 1 INTO tmp FROM AR_LOOKUPS
805: WHERE
806: lookup_type = 'HZ_DOMAIN_ISP_LIST'
807: and lookup_code = tempstr ;
808:

Line 897: SELECT 1 INTO tmp FROM AR_LOOKUPS

893: x_extension := substr(treated_input_str,
894: instrb(treated_input_str,'.',1,I) + 1 );
895: END IF;
896:
897: SELECT 1 INTO tmp FROM AR_LOOKUPS
898: WHERE
899: lookup_type = 'HZ_DOMAIN_SUFFIX_LIST'
900: and lookup_code = x_extension;
901: