APPS.HXC_ALIAS_UTILS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

     SELECT  1
         FROM  hxc_alias_definitions_tl adtl,
               hxc_alias_definitions    ad
         WHERE upper(adtl.alias_definition_name) =
			upper(translate(p_alias_definition_name, '_',' '))
         AND   adtl.alias_definition_id = ad.alias_definition_id
         AND   adtl.language = p_language
         AND   (ad.alias_definition_id <> p_alias_definition_id OR
                p_alias_definition_id IS NULL );

Line: 144

     SELECT  1
         FROM  hxc_alias_values_tl avtl,
               hxc_alias_values    av
         WHERE upper(avtl.alias_value_name) =
                        upper(translate(p_alias_value_name, '_',' '))
         AND   avtl.alias_value_id = av.alias_value_id
         AND   avtl.language = p_language
         AND   (av.alias_value_id <> p_alias_value_id OR
                p_alias_value_id IS NULL );