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

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

Line: 37


    SELECT object_version_number,
      assignment_extra_info_id
    FROM per_assignment_extra_info
    WHERE assignment_id  = p_assig_id
    AND information_type = p_type;

Line: 59


  SELECT report_type
  FROM pay_payroll_actions
  WHERE payroll_action_id = p_pactid;

Line: 88


    SELECT paa.assignment_id,
      paa.assignment_action_id,
      pai.action_information6,  --EXPAT
      pai.action_information7,  --EXPAT
      pai.action_information8,  --EXPAT
      pai.action_information9,  --EXPAT
      pai.action_information10, --EXPAT
      pai.action_information12, --PENSIONER
	  pai.action_information26, --PENSIONER
      pai.action_information4,  --STARTER
      pai.action_information5,  --STARTER
      pai.action_information20  -- Number of Periods Covered
    FROM pay_assignment_actions paa,
      pay_action_information pai
    WHERE paa.payroll_action_id         = p_pactid
    AND paa.assignment_action_id        = pai.action_context_id
    AND pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'
    AND pai.action_context_type         = 'AAP';

Line: 108


    SELECT paa.assignment_id,
      paa.assignment_action_id
    FROM pay_assignment_actions paa
    WHERE paa.payroll_action_id         = p_pactid;

Line: 115


    SELECT paa.assignment_id,
      paa.assignment_action_id,
      pai.action_information6,  --EXPAT
      pai.action_information7,  --EXPAT
      pai.action_information8,  --EXPAT
      pai.action_information9,  --EXPAT
      pai.action_information10, --EXPAT
      pai.action_information12, --PENSIONER
	  pai.action_information26, --PENSIONER
      pai.action_information4,  --STARTER
      pai.action_information5,  --STARTER
      pai.action_information20  -- Number of Periods Covered
    FROM pay_assignment_actions paa,
      pay_action_information pai
    WHERE paa.payroll_action_id         = p_pactid
    AND paa.assignment_action_id        = p_asgactid --9923676
    AND paa.assignment_action_id        = pai.action_context_id
    AND pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'
    AND pai.action_context_type         = 'AAP';

Line: 137


    SELECT report_type
    FROM pay_payroll_actions
    WHERE payroll_action_id = p_pactid;

Line: 162


      hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',
      p_aei_information1 => archive_rec.action_information20);

Line: 169


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
        p_aei_information19 => 'N');

Line: 177


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');

Line: 184


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

Line: 188


    DELETE
    FROM pay_gb_fps_details
    WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
    AND ASSIGNMENT_ID    = archive_rec.ASSIGNMENT_ID;

Line: 196


         DELETE
         FROM pay_gb_fps_details
         WHERE FPS_ASG_ACT_ID = del_rec.ASSIGNMENT_ACTION_ID
         AND ASSIGNMENT_ID    = del_rec.ASSIGNMENT_ID;

Line: 207


      hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',
      p_aei_information1 => l_asgact_rec.action_information20);

Line: 214


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
        p_aei_information19 => 'N');

Line: 222


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');

Line: 229


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

Line: 233


    DELETE
    FROM pay_gb_fps_details
    WHERE FPS_ASG_ACT_ID = l_asgact_rec.ASSIGNMENT_ACTION_ID
    AND ASSIGNMENT_ID    = l_asgact_rec.ASSIGNMENT_ID;

Line: 253


    SELECT paa.assignment_id,
      paa.assignment_action_id,
      pai.action_information5,  --EXPAT
      pai.action_information6,  --EXPAT
      pai.action_information7,  --EXPAT
      pai.action_information8,  --EXPAT
      pai.action_information9, --EXPAT
      pai.action_information11, --PENSIONER
	    pai.action_information12, --PENSIONER
      pai.action_information3,  --STARTER
      pai.action_information4  --STARTER
    FROM pay_assignment_actions paa,
      pay_action_information pai
    WHERE paa.payroll_action_id         = p_pactid
    AND paa.assignment_action_id        = pai.action_context_id
    AND pai.action_information_category = 'GB_RTI_EYU_ASG_DET'
    AND pai.action_context_type         = 'AAP';

Line: 272


    SELECT paa.assignment_id,
      paa.assignment_action_id
    FROM pay_assignment_actions paa
    WHERE paa.payroll_action_id         = p_pactid;

Line: 279


    SELECT paa.assignment_id,
      paa.assignment_action_id,
      pai.action_information5,  --EXPAT
      pai.action_information6,  --EXPAT
      pai.action_information7,  --EXPAT
      pai.action_information8,  --EXPAT
      pai.action_information9, --EXPAT
      pai.action_information11, --PENSIONER
	    pai.action_information12, --PENSIONER
      pai.action_information3,  --STARTER
      pai.action_information4  --STARTER
    FROM pay_assignment_actions paa,
      pay_action_information pai
    WHERE paa.payroll_action_id         = p_pactid
    AND paa.assignment_action_id        = p_asgactid --9923676
    AND paa.assignment_action_id        = pai.action_context_id
    AND pai.action_information_category = 'GB_RTI_EYU_ASG_DET'
    AND pai.action_context_type         = 'AAP';

Line: 300


    SELECT report_type
    FROM pay_payroll_actions
    WHERE payroll_action_id = p_pactid;

Line: 327


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
        p_aei_information19 => 'N');

Line: 335


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');

Line: 342


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

Line: 358


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
        p_aei_information19 => 'N');

Line: 366


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');

Line: 373


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

Line: 399


  SELECT DISTINCT paa.assignment_id
  FROM pay_assignment_actions paa,
       pay_payroll_actions ppa,
       pay_action_information pai
 WHERE paa.payroll_action_id = ppa.payroll_action_id
   AND ppa.payroll_action_id = p_pactid --1688760
   AND paa.assignment_action_id = pai.action_context_id;

Line: 408


select  		fnd_date.canonical_to_date(substr(legislative_parameters,instr(legislative_parameters,'START=') + 6,10)) effective_date,
						substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
     from   pay_payroll_actions
     where  payroll_action_id = p_pactid;

Line: 415


select pai.ACTION_INFORMATION10
from pay_assignment_Actions paa, pay_action_information pai
where paa.payroll_action_id = p_pactid and paa.assignment_id = p_asg_id
	and pai.action_context_id = paa.assignment_Action_id
	and pai.ACTION_INFORMATION_CATEGORY = 'GB RTI EMPLOYEE DETAILS';

Line: 424


	select paaf.assignment_id
	from per_all_assignments_f paaf,
    	 pay_payrolls_f pay,
	     hr_soft_coding_keyflex sck
	where paaf.person_id     =  (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_asg_id)
	and   paaf.assignment_id <> p_asg_id
	and   pay.payroll_id     = paaf.payroll_id
	and   pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
	and   sck.SEGMENT1 = l_tax_ref
	and   paaf.EFFECTIVE_START_DATE =
				( select max(paaf1.effective_start_date)
					from per_all_assignments_f paaf1
					where paaf1.assignment_id = paaf.assignment_id
					and paaf1.assignment_type       = 'E'
					and paaf1.effective_start_date <= l_effective_date
				)
	and l_effective_date between pay.EFFECTIVE_START_DATE and pay.EFFECTIVE_END_DATE;

Line: 456


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

Line: 471


						        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

Line: 499


  SELECT DISTINCT paa.assignment_id
  FROM pay_assignment_actions paa,
       pay_payroll_actions ppa
 WHERE paa.payroll_action_id = ppa.payroll_action_id
   AND ppa.payroll_action_id = p_pactid; --1688760

Line: 507


	select 'Y' from dual where exists(select *
	from   pay_payroll_actions prev,
	pay_assignment_actions paa
    where paa.assignment_id = p_asg_id
	and paa.payroll_action_id = prev.payroll_action_id
	and prev.payroll_action_id <> p_pactid
	and prev.ACTION_STATUS='C'
	and prev.REPORT_TYPE = 'RTI_EAS_REP');

Line: 532


        hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

Line: 550


     select paa.assignment_id,
            pai.action_information1,
            pai.action_information2,
            pai.action_information3,
            pai.action_information4,
            pai.action_information5,
            pai.action_information6,
            pai.action_information7,
            pai.action_information8,
            pai.action_information9,
            pai.action_information10,
            pai.action_information11,
            pai.action_information12
     from   pay_assignment_actions paa,
            pay_action_information pai
     where  paa.payroll_action_id = p_pactid
     and    paa.assignment_action_id = pai.action_context_id
     and    pai.action_information_category = p_type
     and    pai.action_context_type = 'AAP';

Line: 572


        SELECT pei.aei_information_category,
               pei.aei_information1,
	       pei.aei_information2,
	       pei.aei_information3,
	       pei.aei_information4,
	       pei.aei_information5,
	       pei.aei_information6
        FROM per_assignment_extra_info pei
        WHERE pei.assignment_id = l_assignment_id
          AND pei.information_type = 'GB_P46';

Line: 592


               hr_assignment_extra_info_api.update_assignment_extra_info
                      (p_validate                 => false,
                       p_object_version_number    => l_ovn,
                       p_assignment_extra_info_id => l_aei_id,
                       p_aei_information_category => 'GB_WNU',
                       p_aei_information1         => archive_rec.action_information2,
                       p_aei_information2         => archive_rec.action_information3,
                       p_aei_information3         => archive_rec.action_information4);

Line: 611


               hr_assignment_extra_info_api.update_assignment_extra_info
                      (p_validate                 => false,
                       p_object_version_number    => l_ovn,
                       p_assignment_extra_info_id => l_aei_id,
                       p_aei_information_category => 'GB_P45_3',
                       p_aei_information1         => 'Y');

Line: 628


               hr_assignment_extra_info_api.update_assignment_extra_info
                      (p_validate                 => false,
                       p_object_version_number    => l_ovn,
                       p_assignment_extra_info_id => l_aei_id,
                       p_aei_information_category => 'GB_P45_3',
                       p_aei_information1         => 'Y');

Line: 646


               hr_assignment_extra_info_api.update_assignment_extra_info
                      (p_validate                 => false,
                       p_object_version_number    => l_ovn,
                       p_assignment_extra_info_id => l_aei_id,
                       p_aei_information_category => 'GB_P46',
                       p_aei_information1         => 'Y');

Line: 665


               hr_assignment_extra_info_api.update_assignment_extra_info
                      (p_validate                 => false,
                       p_object_version_number    => l_ovn,
                       p_assignment_extra_info_id => l_aei_id,
                       p_aei_information_category => 'GB_P46EXP',
                       p_aei_information1         => 'Y');

Line: 696


                                    hr_assignment_extra_info_api.update_assignment_extra_info
                                      (p_validate                 => false,
		                       p_object_version_number    => l_ovn,
				       p_assignment_extra_info_id => l_aei_id,
		                       p_aei_information_category => 'GB_P46',
				       p_aei_information5         => 'Y');

Line: 706


				     hr_assignment_extra_info_api.update_assignment_extra_info
                                       (p_validate                 => false,
		                        p_object_version_number    => l_ovn,
				        p_assignment_extra_info_id => l_aei_id,
		                        p_aei_information_category => 'GB_P46',
					p_aei_information5         => 'Y',
					p_aei_information1         => NULL,
                                        p_aei_information3         => 'N');

Line: 724


                                hr_assignment_extra_info_api.update_assignment_extra_info
                                  (p_validate                 => false,
                                   p_object_version_number    => l_ovn,
		    	  	   p_assignment_extra_info_id => l_aei_id,
		                   p_aei_information_category => 'GB_P46',
		                   p_aei_information1         => 'Y');

Line: 743


               hr_assignment_extra_info_api.update_assignment_extra_info
                      (p_validate                 => false,
                       p_object_version_number    => l_ovn,
                       p_assignment_extra_info_id => l_aei_id,
                       p_aei_information_category => 'GB_P46PENNOT',
                       p_aei_information1         => 'Y');