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.PER_IN_PREV_EMPLOYER_LEG_HOOK SQL Statements

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

Line: 123


      SELECT global_value
      FROM   ff_globals_f
      WHERE  global_name = 'IN_PTAX_CEILING'
      AND    p_effective_date between effective_start_date and effective_end_date;

Line: 130


     SELECT 'X'
     FROM   per_person_types ppt,
            per_person_type_usages_f pptu
     WHERE ppt.person_type_id = pptu.person_type_id
     AND ppt.business_group_id = p_business_group_id
     AND pptu.person_id = p_person_id
     AND p_effective_date BETWEEN pptu.effective_start_date
     AND pptu.effective_end_date AND ppt.system_person_type = 'EMP';

Line: 493


PROCEDURE check_prev_emp_update(
          p_effective_date       IN DATE
         ,p_previous_employer_id IN NUMBER
         ,p_start_date           IN DATE
         ,p_end_date             IN DATE
         ,p_pem_information_category IN VARCHAR2
         ,p_pem_information1     IN VARCHAR2
         ,p_pem_information2     IN VARCHAR2
         ,p_pem_information3     IN VARCHAR2
         ,p_pem_information4     IN VARCHAR2
         ,p_pem_information5     IN VARCHAR2
         ,p_pem_information6     IN VARCHAR2
         ,p_pem_information7     IN VARCHAR2
         ,p_pem_information8     IN VARCHAR2
         ,p_pem_information9     IN VARCHAR2
         ,p_pem_information10    IN VARCHAR2
         ,p_pem_information11    IN VARCHAR2
         ,p_pem_information12    IN VARCHAR2
         ,p_pem_information13    IN VARCHAR2
         ,p_pem_information14    IN VARCHAR2
         ,p_pem_information15    IN VARCHAR2
         ,p_pem_information16    IN VARCHAR2
         ,p_pem_information17    IN VARCHAR2
         ,p_pem_information18    IN VARCHAR2
         ,p_pem_information19    IN VARCHAR2
         ,p_pem_information20    IN VARCHAR2
         ,p_pem_information21    IN VARCHAR2
         ,p_pem_information22    IN VARCHAR2
         ,p_pem_information23    IN VARCHAR2
         ,p_pem_information24    IN VARCHAR2
         ,p_pem_information25    IN VARCHAR2
         ,p_pem_information26    IN VARCHAR2
         ,p_pem_information27    IN VARCHAR2
         ,p_pem_information28    IN VARCHAR2
         ,p_pem_information29    IN VARCHAR2
         ,p_pem_information30    IN VARCHAR2)
IS

   CURSOR c_pem_id IS
      SELECT business_group_id
            ,person_id
            ,start_date
	    ,end_date
	    ,pem_information_category
	    ,pem_information1
            ,pem_information2
            ,pem_information3
            ,pem_information4
            ,pem_information5
            ,pem_information6
            ,pem_information7
            ,pem_information8
            ,pem_information9
            ,pem_information10
            ,pem_information11
            ,pem_information12
            ,pem_information13
            ,pem_information14
            ,pem_information15
            ,pem_information16
            ,pem_information17
            ,pem_information18
            ,pem_information19
            ,pem_information20
            ,pem_information21
            ,pem_information22
            ,pem_information23
            ,pem_information24
	    ,pem_information25
	    ,pem_information26
	    ,pem_information27
	    ,pem_information28
	    ,pem_information29
	    ,pem_information30
      FROM   per_previous_employers
      WHERE  previous_employer_id = p_previous_employer_id;

Line: 610


  l_procedure := g_package||'check_prev_emp_update';

Line: 884


END check_prev_emp_update;