APPS.HR_SA_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;