APPS.HR_CA_UTILITY SQL Statements

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

Line: 56

      SELECT meaning
      INTO   l_title_meaning
      FROM   hr_lookups
      WHERE  lookup_type = 'TITLE'
      AND    p_title     = lookup_code;

Line: 64

  SELECT SUBSTR(DECODE(p_pre_name_adjunct,'','',p_pre_name_adjunct||' ')||
                      p_last_name||','||DECODE(l_title_meaning,'','',
                      ' '||l_title_meaning)|| DECODE(p_first_name,'','',
                      ' '||p_first_name)||DECODE(p_middle_names,'','',
                      ' '||p_middle_names)||
                      DECODE(p_suffix,'','',' '||p_suffix),1,240)
  INTO  l_full_name
  FROM sys.dual ;

Line: 125

  SELECT SUBSTR(DECODE(p_pre_name_adjunct,'','',p_pre_name_adjunct||' ')||
                      p_last_name||','||
                      DECODE(p_first_name,'','',
                      ' '||p_first_name)||DECODE(p_middle_names,'','',
                      ' '||p_middle_names)||
                      DECODE(p_suffix,'','',' '||p_suffix)||
                      DECODE(p_known_as,'','',
                      ' ('||p_known_as||')'),1,240)
  INTO  l_order_name
  FROM sys.dual ;