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.

[Home] [Help]

APPS.HR_NL_UTILITY SQL Statements

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

Line: 52


SELECT se.effective_date effective_date
FROM fnd_sessions se
WHERE se.session_id = USERENV('sessionid');

Line: 59


SELECT pcr.contact_person_id contact_person_id
FROM per_contact_relationships pcr
WHERE  pcr.person_id=per_per_shd.g_old_rec.person_id
  AND pcr.contact_type='S'
  AND c_effective_date between nvl(pcr.date_start,to_date('01/01/0001','dd/mm/yyyy')) and nvl(pcr.date_end,to_date('31/12/4712','dd/mm/yyyy'))
;

Line: 69


SELECT papf.pre_name_adjunct prefix
      ,papf.last_name last_name
FROM per_all_people_f papf
WHERE papf.person_id=c_person_id
  AND c_effective_date between papf.effective_start_date and papf.effective_end_date
  AND papf.person_type_id  IN (
                                  SELECT ppt.person_type_id
				  FROM per_person_types ppt
				  WHERE ppt.business_group_id=papf.business_group_id
                                    AND ppt.seeded_person_type_key='CONTACT') ;

Line: 155


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

Line: 163


     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: 170


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

Line: 179


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

Line: 189


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

Line: 198


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

Line: 208


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

Line: 217


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

Line: 226


     select decode (p_per_information1,'','',p_per_information1 || ' ')
            || decode (l_per_information5,'','',l_per_information5 || ' ')
            || l_per_information6
     into l_full_name
     from dual;

Line: 233


      	 select decode (l_per_information6,'','',l_per_information6 || ' ')
      	       || decode (l_per_information5,'','',l_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: 242


      	 select decode (l_per_information6,'','',l_per_information6 || ' ')
      	       || decode (l_per_information5,'','',l_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: 251


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

Line: 257


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

Line: 263


     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: 270


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

Line: 279


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

Line: 288


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

Line: 294


     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: 301


     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: 308


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

Line: 314


     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: 323


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (l_per_information5,'','',l_per_information5 || ' ')
     	       || decode (l_per_information6,'','',l_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: 334


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (l_per_information5,'','',l_per_information5 || ' ')
	       || decode (l_per_information6,'','',l_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: 346


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

Line: 355


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

Line: 364


     	 select decode (l_per_information6,'','',l_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 (l_per_information5,'','',l_per_information5 || ' ')
	 into l_full_name
     	 from dual;

Line: 373


     	 select decode (l_per_information6,'','',l_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 (l_per_information5,'','',l_per_information5 || ' ')
	 into l_full_name
     	 from dual;

Line: 383


     	 select p_last_name || '-'
     	       || decode (l_per_information5,'','',l_per_information5 || ' ')
     	       || decode (l_per_information6,'','',l_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: 392


     	 select p_last_name || '-'
	       || decode (l_per_information5,'','',l_per_information5 || ' ')
	       || decode (l_per_information6,'','',l_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: 400


       	 select p_last_name || ''
	       || decode (l_per_information5,'','',l_per_information5 || ' ')
	       || decode (l_per_information6,'','',l_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: 409


       	 select p_last_name || ''
	       || decode (l_per_information5,'','',l_per_information5 || ' ')
	       || decode (l_per_information6,'','',l_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: 419


     	 select decode (l_per_information6,'','',l_per_information6)
     	       || ', '
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (l_per_information5,'','',l_per_information5 || ' ')
     	 into l_full_name
    	 from dual;

Line: 426


    	 select decode (l_per_information6,'','',l_per_information6|| ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (l_per_information5,'','',l_per_information5 || ' ')
	 into l_full_name
    	 from dual;

Line: 433


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

Line: 442


     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: 452


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
     	       || decode (l_title,'','',l_title|| ' ')
     	       || decode (p_per_information1,'','',p_per_information1 || ' ')
     	       || decode (l_per_information5,'','',l_per_information5 || ' ')
     	       || decode (l_per_information6,'','',l_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: 464


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
	       || decode (l_title,'','',l_title|| ' ')
	       || decode (p_per_information1,'','',p_per_information1 || ' ')
	       || decode (l_per_information5,'','',l_per_information5 || ' ')
	       || decode (l_per_information6,'','',l_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: 476


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

Line: 485


     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: 495


    	 select decode (l_acad_title,'','',l_acad_title|| ' ')
    	       || decode (l_title,'','',l_title|| ' ')
    	       || decode (p_first_name,'','',p_first_name|| ' ')
    	       || decode (l_per_information5,'','',l_per_information5 || ' ')
    	       || decode (l_per_information6,'','',l_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: 507


     	 select decode (l_acad_title,'','',l_acad_title|| ' ')
	       || decode (l_title,'','',l_title|| ' ')
	       || decode (p_first_name,'','',p_first_name|| ' ')
	       || decode (l_per_information5,'','',l_per_information5 || ' ')
	       || decode (l_per_information6,'','',l_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: 519


     select p_last_name ||','|| ' ' /* 9346754QA */
            || decode (p_per_information1,'','',p_per_information1 || ' ')
            || p_pre_name_adjunct
     into l_full_name
     from dual;

Line: 525


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