APPS.HR_DE_UTILITY SQL Statements

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

Line: 57

   SELECT SUBSTR(LTRIM(RTRIM(p_last_name
                          || DECODE(p_first_name
                                   ,null, ' '
                                   ,', ' || p_first_name || ' ')
                          || DECODE(p_per_information10
                                   ,null, ''
                                   ,hr_general.decode_lookup('DE_PREFIX', p_per_information10))
                            )), 1, 240)
   INTO   l_full_name
   FROM   dual;