APPS.PAY_GB_EDI_ROLLBACK SQL Statements

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

Line: 47

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

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

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

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

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

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

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

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

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

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

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

               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');