APPS.PAY_KR_AEI_API SQL Statements

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

Line: 17

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;

Line: 134

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  );

Line: 250

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  ,p_aei_information5           => p_aei_information5
  ,p_aei_information6           => p_aei_information6
  ,p_aei_information7           => p_aei_information7
  );

Line: 414

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  ,p_aei_information5           => p_aei_information5
  ,p_aei_information6           => p_aei_information6
  ,p_aei_information7           => p_aei_information7
  ,p_aei_information8           => p_aei_information8
  ,p_aei_information9           => p_aei_information9
  ,p_aei_information10          => p_aei_information10
  ,p_aei_information11          => p_aei_information11
  ,p_aei_information12          => p_aei_information12
  ,p_aei_information13          => p_aei_information13
  ,p_aei_information14          => p_aei_information14
  ,p_aei_information15          => p_aei_information15
  ,p_aei_information16          => p_aei_information16
  ,p_aei_information17          => p_aei_information17
  ,p_aei_information18          => p_aei_information18
  ,p_aei_information19          => p_aei_information19
  ,p_aei_information20          => p_aei_information20
  ,p_aei_information21          => p_aei_information21
  ,p_aei_information22          => p_aei_information22
  );

Line: 539

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  );

Line: 652

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  ,p_aei_information5           => p_aei_information5
  ,p_aei_information6           => p_aei_information6
  );

Line: 779

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  ,p_aei_information5           => p_aei_information5
  ,p_aei_information6           => p_aei_information6
  ,p_aei_information7           => p_aei_information7
  ,p_aei_information8           => p_aei_information8
  ,p_aei_information9           => p_aei_information9
  ,p_aei_information10          => p_aei_information10
  );

Line: 847

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  ,p_aei_information5           => p_aei_information5
  ,p_aei_information6           => p_aei_information6
  ,p_aei_information7           => p_aei_information7
  ,p_aei_information8           => p_aei_information8
  ,p_aei_information9           => p_aei_information9
  ,p_aei_information10          => p_aei_information10
  ,p_aei_information11          => p_aei_information11
  ,p_aei_information12          => p_aei_information12
  ,p_aei_information13          => p_aei_information13
  ,p_aei_information14          => p_aei_information14
  ,p_aei_information15          => p_aei_information15
  );