APPS.HR_AE_UTILITY SQL Statements

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

Line: 60

   SELECT SUBSTR(LTRIM(RTRIM (DECODE(p_first_name, null,'',' ' || p_first_name)
          ||DECODE(p_per_information1, null, '', ' ' || p_per_information1) -- Father
          ||DECODE(p_per_information2, null, '', ' ' || p_per_information2) -- Grandfather
          ||DECODE(p_last_name, null, '', ' '||p_last_name)
                )), 1, 240)
   INTO   l_full_name
   FROM   dual;

Line: 148

  SELECT DISTINCT MEANING
  INTO v_city_name
  FROM HR_LOOKUPS H
  WHERE H.LOOKUP_TYPE='AE_CITY_CODES'
  AND H.LOOKUP_CODE = p_town_or_city
  AND H.ENABLED_FLAG = 'Y'
  AND H.APPLICATION_ID = 800;