eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NL_UTILITY SQL Statements

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

Line: 57


     select p_last_name || ' '
            || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || decode (p_per_information5,'','',p_per_information5 || ' ')
            || p_per_information6
     into l_full_name
     from dual;

Line: 65


     select decode (p_per_information1,'','',p_per_information1 || ' ')
            || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
            || p_last_name
     into l_full_name
     from dual;

Line: 72


     	  select decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || decode (p_per_information6,'','',p_per_information6)
     	       || '-'
               || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
     	       || p_last_name
     	  into l_full_name
     	  from dual;

Line: 81


      	 select decode (p_per_information1,'','',p_per_information1 || ' ')
	        || decode (p_per_information5,'','',p_per_information5 || ' ')
	        || decode (p_per_information6,'','',p_per_information6 || ' ')
	        || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	        || p_last_name
	 into l_full_name
     	 from dual;

Line: 91


     	 select decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
     	       || p_last_name
     	       || '-'
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || p_per_information6
    	 into l_full_name
    	 from dual;

Line: 100


    	 select decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	       || p_last_name || ' '
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || p_per_information6
	 into l_full_name
    	 from dual;

Line: 110


     	 select p_last_name || ' '
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct)
     	       || ', '
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || p_per_information6
     	 into l_full_name
     	 from dual;

Line: 119


     	 select p_last_name || ' '
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || p_per_information6
	 into l_full_name
     	 from dual;

Line: 128


     select decode (p_per_information1,'','',p_per_information1 || ' ')
            || decode (p_per_information5,'','',p_per_information5 || ' ')
            || p_per_information6
     into l_full_name
     from dual;

Line: 135


      	 select decode (p_per_information6,'','',p_per_information6 || ' ')
      	       || decode (p_per_information5,'','',p_per_information5)
      	       || ', '
      	       || decode (p_per_information1,'','',p_per_information1 || ' ')
      	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
      	       || p_last_name
     	 into l_full_name
      	 from dual;

Line: 144


      	 select decode (p_per_information6,'','',p_per_information6 || ' ')
      	       || decode (p_per_information5,'','',p_per_information5 || ' ')
               || decode (p_per_information1,'','',p_per_information1 || ' ')
               || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
               || p_last_name
         into l_full_name
      	 from dual;

Line: 153


     select p_last_name || ' '
            || decode (p_first_name,'','',p_first_name|| ' ')
            || p_pre_name_adjunct
     into l_full_name
     from dual;

Line: 159


     select p_last_name || ' '
            || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct|| ' ')
            || p_first_name
     into l_full_name
     from dual;

Line: 165


     select decode (p_first_name,'','',p_first_name|| ' ')
            || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct|| ' ')
            || p_last_name
     into l_full_name
     from dual;

Line: 172


     	 select decode (p_first_name,'','',p_first_name|| ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || decode (p_per_information6,'','',p_per_information6)
     	       || '-'
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
     	       || p_last_name
     	 into l_full_name
     	 from dual;

Line: 181


     	 select decode (p_first_name,'','',p_first_name|| ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || decode (p_per_information6,'','',p_per_information6 || ' ')
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
     	       || p_last_name
     	 into l_full_name
     	 from dual;

Line: 190


     select p_last_name || ' '
            || decode (l_title,'','',l_title|| ' ')
            || p_per_information1
     into l_full_name
     from dual;

Line: 196


     select p_last_name || ' '
            || decode (l_title,'','',l_title|| ' ')
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || p_first_name
     into l_full_name
     from dual;

Line: 203


     select p_last_name || ' '
            || decode (l_title,'','',l_title|| ' ')
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || p_known_as
     into l_full_name
     from dual;

Line: 210


     select p_last_name || ' '
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || p_pre_name_adjunct
     into l_full_name
     from dual;

Line: 216


     select decode (l_acad_title,'','',l_acad_title|| ' ')
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
            || p_last_name || ' '
            || decode (l_sub_acad_title,'','',l_sub_acad_title|| ' ')
     into l_full_name
     from dual;

Line: 225


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || decode (p_per_information6,'','',p_per_information6)
     	       || '-'
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
     	       || p_last_name || ' '
     	       || decode (l_sub_acad_title,'','',l_sub_acad_title|| ' ')
     	 into l_full_name
     	 from dual;

Line: 236


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || decode (p_per_information6,'','',p_per_information6 || ' ')
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	       || p_last_name || ' '
	       || decode (l_sub_acad_title,'','',l_sub_acad_title|| ' ')
	 into l_full_name
     	 from dual;

Line: 248


     	 select decode (p_per_information6,'','',p_per_information6)
     	       || '-'
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
     	       || p_last_name || ', '
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	 into l_full_name
     	 from dual;

Line: 257


     	 select decode (p_per_information6,'','',p_per_information6)
     	       || '-'
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	       || p_last_name || ''
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	 into l_full_name
     	 from dual;

Line: 266


     	 select decode (p_per_information6,'','',p_per_information6)
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct)
	       || decode (p_last_name, '','',p_last_name)
	       || ', '
	       || decode (p_per_information1,'','', ', ' || p_per_information1 || ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	 into l_full_name
     	 from dual;

Line: 275


     	 select decode (p_per_information6,'','',p_per_information6)
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	       || decode (p_last_name, '','',p_last_name || ', ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	 into l_full_name
     	 from dual;

Line: 285


     	 select p_last_name || '-'
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || decode (p_per_information6,'','',p_per_information6)
     	       || ', '
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
         into l_full_name
     	 from dual;

Line: 294


     	 select p_last_name || '-'
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || decode (p_per_information6,'','',p_per_information6 || ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	 into l_full_name
	 from dual;

Line: 302


       	 select p_last_name || ''
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || decode (p_per_information6,'','',p_per_information6)
	       || ', '
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	 into l_full_name
	 from dual;

Line: 311


       	 select p_last_name || ''
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || decode (p_per_information6,'','',p_per_information6 || ', ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	 into l_full_name
	 from dual;

Line: 321


     	 select decode (p_per_information6,'','',p_per_information6)
     	       || ', '
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	 into l_full_name
    	 from dual;

Line: 328


    	 select decode (p_per_information6,'','',p_per_information6|| ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	 into l_full_name
    	 from dual;

Line: 335


     select decode (l_acad_title,'','',l_acad_title|| ' ')
            || decode (l_title,'','',l_title|| ' ')
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || decode (p_per_information5,'','',p_per_information5 || ' ')
            || decode (p_per_information6,'','',p_per_information6 || ' ')
            || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
         into l_full_name
     from dual;

Line: 344


     select decode (l_acad_title,'','',l_acad_title|| ' ')
            || decode (l_title,'','',l_title|| ' ')
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
            || p_last_name || ' '
            || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
         into l_full_name
     from dual;

Line: 354


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
     	       || decode (l_title,'','',l_title|| ' ')
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (p_per_information5,'','',p_per_information5 || ' ')
     	       || decode (p_per_information6,'','',p_per_information6)
     	       || '-'
     	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
     	       || p_last_name || ' '
     	       || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
         into l_full_name
     	 from dual;

Line: 366


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
	       || decode (l_title,'','',l_title|| ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || decode (p_per_information6,'','',p_per_information6 || ' ')
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	       || p_last_name || ' '
	       || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
	 into l_full_name
     	 from dual;

Line: 378


     select decode (l_acad_title,'','',l_acad_title|| ' ')
            || decode (l_title,'','',l_title|| ' ')
            || decode (p_first_name,'','',p_first_name|| ' ')
            || decode (p_per_information5,'','',p_per_information5 || ' ')
            || decode (p_per_information6,'','',p_per_information6 || ' ')
            || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
         into l_full_name
     from dual;

Line: 387


     select decode (l_acad_title,'','',l_acad_title|| ' ')
            || decode (l_title,'','',l_title|| ' ')
            || decode (p_first_name,'','',p_first_name|| ' ')
            || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
            || p_last_name || ' '
            || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
         into l_full_name
     from dual;

Line: 397


    	 select decode (l_acad_title,'','',l_acad_title|| ' ')
    	       || decode (l_title,'','',l_title|| ' ')
    	       || decode (p_first_name,'','',p_first_name|| ' ')
    	       || decode (p_per_information5,'','',p_per_information5 || ' ')
    	       || decode (p_per_information6,'','',p_per_information6)
    	       || '-'
    	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
    	       || p_last_name || ' '
    	       || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
         into l_full_name
     	 from dual;

Line: 409


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
	       || decode (l_title,'','',l_title|| ' ')
	       || decode (p_first_name,'','',p_first_name|| ' ')
	       || decode (p_per_information5,'','',p_per_information5 || ' ')
	       || decode (p_per_information6,'','',p_per_information6 || ' ')
	       || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
	       || p_last_name || ' '
	       || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
	 into l_full_name
     	 from dual;

Line: 421


     select p_last_name || ' '
           || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
           || decode (p_per_information1,'','',p_per_information1 || ' ')
           || decode (p_per_information5,'','',p_per_information5 || ' ')
           || p_per_information6
     into l_full_name
     from dual;