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

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

Line: 12


procedure update_pds_details
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_period_of_service_id          in     number
  ,p_termination_accepted_person   in     number   default hr_api.g_number
  ,p_accepted_termination_date     in     date     default hr_api.g_date
  ,p_object_version_number         in out nocopy number
  ,p_comments                      in     varchar2 default hr_api.g_varchar2
  ,p_leaving_reason                in     varchar2 default hr_api.g_varchar2
  ,p_notified_termination_date     in     date     default hr_api.g_date
  ,p_projected_termination_date    in     date     default hr_api.g_date
  ,p_actual_termination_date       in     date     default hr_api.g_date
  ,p_last_standard_process_date    in     date     default hr_api.g_date
  ,p_final_process_date            in     date     default hr_api.g_date
  ,p_attribute_category            in varchar2     default hr_api.g_varchar2
  ,p_attribute1                    in varchar2     default hr_api.g_varchar2
  ,p_attribute2                    in varchar2     default hr_api.g_varchar2
  ,p_attribute3                    in varchar2     default hr_api.g_varchar2
  ,p_attribute4                    in varchar2     default hr_api.g_varchar2
  ,p_attribute5                    in varchar2     default hr_api.g_varchar2
  ,p_attribute6                    in varchar2     default hr_api.g_varchar2
  ,p_attribute7                    in varchar2     default hr_api.g_varchar2
  ,p_attribute8                    in varchar2     default hr_api.g_varchar2
  ,p_attribute9                    in varchar2     default hr_api.g_varchar2
  ,p_attribute10                   in varchar2     default hr_api.g_varchar2
  ,p_attribute11                   in varchar2     default hr_api.g_varchar2
  ,p_attribute12                   in varchar2     default hr_api.g_varchar2
  ,p_attribute13                   in varchar2     default hr_api.g_varchar2
  ,p_attribute14                   in varchar2     default hr_api.g_varchar2
  ,p_attribute15                   in varchar2     default hr_api.g_varchar2
  ,p_attribute16                   in varchar2     default hr_api.g_varchar2
  ,p_attribute17                   in varchar2     default hr_api.g_varchar2
  ,p_attribute18                   in varchar2     default hr_api.g_varchar2
  ,p_attribute19                   in varchar2     default hr_api.g_varchar2
  ,p_attribute20                   in varchar2     default hr_api.g_varchar2
  ,p_pds_information_category      in varchar2     default hr_api.g_varchar2
  ,p_pds_information1              in varchar2     default hr_api.g_varchar2
  ,p_pds_information2              in varchar2     default hr_api.g_varchar2
  ,p_pds_information3              in varchar2     default hr_api.g_varchar2
  ,p_pds_information4              in varchar2     default hr_api.g_varchar2
  ,p_pds_information5              in varchar2     default hr_api.g_varchar2
  ,p_pds_information6              in varchar2     default hr_api.g_varchar2
  ,p_pds_information7              in varchar2     default hr_api.g_varchar2
  ,p_pds_information8              in varchar2     default hr_api.g_varchar2
  ,p_pds_information9              in varchar2     default hr_api.g_varchar2
  ,p_pds_information10             in varchar2     default hr_api.g_varchar2
  ,p_pds_information11             in varchar2     default hr_api.g_varchar2
  ,p_pds_information12             in varchar2     default hr_api.g_varchar2
  ,p_pds_information13             in varchar2     default hr_api.g_varchar2
  ,p_pds_information14             in varchar2     default hr_api.g_varchar2
  ,p_pds_information15             in varchar2     default hr_api.g_varchar2
  ,p_pds_information16             in varchar2     default hr_api.g_varchar2
  ,p_pds_information17             in varchar2     default hr_api.g_varchar2
  ,p_pds_information18             in varchar2     default hr_api.g_varchar2
  ,p_pds_information19             in varchar2     default hr_api.g_varchar2
  ,p_pds_information20             in varchar2     default hr_api.g_varchar2
  ,p_pds_information21             in varchar2     default hr_api.g_varchar2
  ,p_pds_information22             in varchar2     default hr_api.g_varchar2
  ,p_pds_information23             in varchar2     default hr_api.g_varchar2
  ,p_pds_information24             in varchar2     default hr_api.g_varchar2
  ,p_pds_information25             in varchar2     default hr_api.g_varchar2
  ,p_pds_information26             in varchar2     default hr_api.g_varchar2
  ,p_pds_information27             in varchar2     default hr_api.g_varchar2
  ,p_pds_information28             in varchar2     default hr_api.g_varchar2
  ,p_pds_information29             in varchar2     default hr_api.g_varchar2
  ,p_pds_information30             in varchar2     default hr_api.g_varchar2
   ) is
  --
  l_org_now_no_manager_warning BOOLEAN := FALSE;

Line: 86


  update_pds_details
    (p_validate                      => p_validate
    ,p_effective_date                => p_effective_date
    ,p_period_of_service_id          => p_period_of_service_id
    ,p_termination_accepted_person   => p_termination_accepted_person
    ,p_accepted_termination_date     => p_accepted_termination_date
    ,p_object_version_number         => p_object_version_number
    ,p_comments                      => p_comments
    ,p_leaving_reason                => p_leaving_reason
    ,p_notified_termination_date     => p_notified_termination_date
    ,p_projected_termination_date    => p_projected_termination_date
    ,p_actual_termination_date       => p_actual_termination_date
    ,p_last_standard_process_date    => p_last_standard_process_date
    ,p_final_process_date            => p_final_process_date
    ,p_attribute_category            => p_attribute_category
    ,p_attribute1                    => p_attribute1
    ,p_attribute2                    => p_attribute2
    ,p_attribute3                    => p_attribute3
    ,p_attribute4                    => p_attribute4
    ,p_attribute5                    => p_attribute5
    ,p_attribute6                    => p_attribute6
    ,p_attribute7                    => p_attribute7
    ,p_attribute8                    => p_attribute8
    ,p_attribute9                    => p_attribute9
    ,p_attribute10                   => p_attribute10
    ,p_attribute11                   => p_attribute11
    ,p_attribute12                   => p_attribute12
    ,p_attribute13                   => p_attribute13
    ,p_attribute14                   => p_attribute14
    ,p_attribute15                   => p_attribute15
    ,p_attribute16                   => p_attribute16
    ,p_attribute17                   => p_attribute17
    ,p_attribute18                   => p_attribute18
    ,p_attribute19                   => p_attribute19
    ,p_attribute20                   => p_attribute20
    ,p_pds_information_category      => p_pds_information_category
    ,p_pds_information1              => p_pds_information1
    ,p_pds_information2              => p_pds_information2
    ,p_pds_information3              => p_pds_information3
    ,p_pds_information4              => p_pds_information4
    ,p_pds_information5              => p_pds_information5
    ,p_pds_information6              => p_pds_information6
    ,p_pds_information7              => p_pds_information7
    ,p_pds_information8              => p_pds_information8
    ,p_pds_information9              => p_pds_information9
    ,p_pds_information10             => p_pds_information10
    ,p_pds_information11             => p_pds_information11
    ,p_pds_information12             => p_pds_information12
    ,p_pds_information13             => p_pds_information13
    ,p_pds_information14             => p_pds_information14
    ,p_pds_information15             => p_pds_information15
    ,p_pds_information16             => p_pds_information16
    ,p_pds_information17             => p_pds_information17
    ,p_pds_information18             => p_pds_information18
    ,p_pds_information19             => p_pds_information19
    ,p_pds_information20             => p_pds_information20
    ,p_pds_information21             => p_pds_information21
    ,p_pds_information22             => p_pds_information22
    ,p_pds_information23             => p_pds_information23
    ,p_pds_information24             => p_pds_information24
    ,p_pds_information25             => p_pds_information25
    ,p_pds_information26             => p_pds_information26
    ,p_pds_information27             => p_pds_information27
    ,p_pds_information28             => p_pds_information28
    ,p_pds_information29             => p_pds_information29
    ,p_pds_information30             => p_pds_information30
    ,p_org_now_no_manager_warning    => l_org_now_no_manager_warning
    ,p_asg_future_changes_warning    => l_asg_future_changes_warning
    ,p_entries_changed_warning       => l_entries_changed_warning
    );

Line: 157


end update_pds_details;

Line: 163


procedure update_pds_details
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_period_of_service_id          in     number
  ,p_termination_accepted_person   in     number   default hr_api.g_number
  ,p_accepted_termination_date     in     date     default hr_api.g_date
  ,p_object_version_number         in out nocopy number
  ,p_comments                      in     varchar2 default hr_api.g_varchar2
  ,p_leaving_reason                in     varchar2 default hr_api.g_varchar2
  ,p_notified_termination_date     in     date     default hr_api.g_date
  ,p_projected_termination_date    in     date     default hr_api.g_date
--
-- 115.9 (START)
--
  ,p_actual_termination_date       in     date     default hr_api.g_date
  ,p_last_standard_process_date    in     date     default hr_api.g_date
  ,p_final_process_date            in     date     default hr_api.g_date
--
-- 115.9 (END)
--
  ,p_attribute_category            in varchar2     default hr_api.g_varchar2
  ,p_attribute1                    in varchar2     default hr_api.g_varchar2
  ,p_attribute2                    in varchar2     default hr_api.g_varchar2
  ,p_attribute3                    in varchar2     default hr_api.g_varchar2
  ,p_attribute4                    in varchar2     default hr_api.g_varchar2
  ,p_attribute5                    in varchar2     default hr_api.g_varchar2
  ,p_attribute6                    in varchar2     default hr_api.g_varchar2
  ,p_attribute7                    in varchar2     default hr_api.g_varchar2
  ,p_attribute8                    in varchar2     default hr_api.g_varchar2
  ,p_attribute9                    in varchar2     default hr_api.g_varchar2
  ,p_attribute10                   in varchar2     default hr_api.g_varchar2
  ,p_attribute11                   in varchar2     default hr_api.g_varchar2
  ,p_attribute12                   in varchar2     default hr_api.g_varchar2
  ,p_attribute13                   in varchar2     default hr_api.g_varchar2
  ,p_attribute14                   in varchar2     default hr_api.g_varchar2
  ,p_attribute15                   in varchar2     default hr_api.g_varchar2
  ,p_attribute16                   in varchar2     default hr_api.g_varchar2
  ,p_attribute17                   in varchar2     default hr_api.g_varchar2
  ,p_attribute18                   in varchar2     default hr_api.g_varchar2
  ,p_attribute19                   in varchar2     default hr_api.g_varchar2
  ,p_attribute20                   in varchar2     default hr_api.g_varchar2
  ,p_pds_information_category      in varchar2     default hr_api.g_varchar2
  ,p_pds_information1              in varchar2     default hr_api.g_varchar2
  ,p_pds_information2              in varchar2     default hr_api.g_varchar2
  ,p_pds_information3              in varchar2     default hr_api.g_varchar2
  ,p_pds_information4              in varchar2     default hr_api.g_varchar2
  ,p_pds_information5              in varchar2     default hr_api.g_varchar2
  ,p_pds_information6              in varchar2     default hr_api.g_varchar2
  ,p_pds_information7              in varchar2     default hr_api.g_varchar2
  ,p_pds_information8              in varchar2     default hr_api.g_varchar2
  ,p_pds_information9              in varchar2     default hr_api.g_varchar2
  ,p_pds_information10             in varchar2     default hr_api.g_varchar2
  ,p_pds_information11             in varchar2     default hr_api.g_varchar2
  ,p_pds_information12             in varchar2     default hr_api.g_varchar2
  ,p_pds_information13             in varchar2     default hr_api.g_varchar2
  ,p_pds_information14             in varchar2     default hr_api.g_varchar2
  ,p_pds_information15             in varchar2     default hr_api.g_varchar2
  ,p_pds_information16             in varchar2     default hr_api.g_varchar2
  ,p_pds_information17             in varchar2     default hr_api.g_varchar2
  ,p_pds_information18             in varchar2     default hr_api.g_varchar2
  ,p_pds_information19             in varchar2     default hr_api.g_varchar2
  ,p_pds_information20             in varchar2     default hr_api.g_varchar2
  ,p_pds_information21             in varchar2     default hr_api.g_varchar2
  ,p_pds_information22             in varchar2     default hr_api.g_varchar2
  ,p_pds_information23             in varchar2     default hr_api.g_varchar2
  ,p_pds_information24             in varchar2     default hr_api.g_varchar2
  ,p_pds_information25             in varchar2     default hr_api.g_varchar2
  ,p_pds_information26             in varchar2     default hr_api.g_varchar2
  ,p_pds_information27             in varchar2     default hr_api.g_varchar2
  ,p_pds_information28             in varchar2     default hr_api.g_varchar2
  ,p_pds_information29             in varchar2     default hr_api.g_varchar2
  ,p_pds_information30             in varchar2     default hr_api.g_varchar2
--
-- 115.9 (START)
--
  ,p_org_now_no_manager_warning    OUT NOCOPY      BOOLEAN
  ,p_asg_future_changes_warning    OUT NOCOPY      BOOLEAN
  ,p_entries_changed_warning       OUT NOCOPY      VARCHAR2
--
-- 115.9 (END)
--
   ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                       varchar2(72) := g_package||'update_pds_details';

Line: 274


select * from per_periods_of_service
where period_of_service_id = p_period_of_service_id;

Line: 278


select * from per_all_people_f
where person_id = p_person_id
and effective_start_date >= p_date;

Line: 290


  savepoint update_pds_details;

Line: 297


   hr_periods_of_service_bk1.update_pds_details_b
     (p_effective_date                => p_effective_date
     ,p_period_of_service_id          => p_period_of_service_id
     ,p_termination_accepted_person   => p_termination_accepted_person
     ,p_accepted_termination_date     => p_accepted_termination_date
     ,p_comments                      => p_comments
     ,p_leaving_reason                => p_leaving_reason
     ,p_notified_termination_date     => p_notified_termination_date
     ,p_projected_termination_date    => p_projected_termination_date
     ,p_actual_termination_date       => p_actual_termination_date
     ,p_last_standard_process_date    => p_last_standard_process_date
     ,p_final_process_date            => p_final_process_date
     ,p_attribute_category            => p_attribute_category
     ,p_attribute1                    => p_attribute1
     ,p_attribute2                    => p_attribute2
     ,p_attribute3                    => p_attribute3
     ,p_attribute4                    => p_attribute4
     ,p_attribute5                    => p_attribute5
     ,p_attribute6                    => p_attribute6
     ,p_attribute7                    => p_attribute7
     ,p_attribute8                    => p_attribute8
     ,p_attribute9                    => p_attribute9
     ,p_attribute10                   => p_attribute10
     ,p_attribute11                   => p_attribute11
     ,p_attribute12                   => p_attribute12
     ,p_attribute13                   => p_attribute13
     ,p_attribute14                   => p_attribute14
     ,p_attribute15                   => p_attribute15
     ,p_attribute16                   => p_attribute16
     ,p_attribute17                   => p_attribute17
     ,p_attribute18                   => p_attribute18
     ,p_attribute19                   => p_attribute19
     ,p_attribute20                   => p_attribute20
     ,p_pds_information_category      => p_pds_information_category
     ,p_pds_information1              => p_pds_information1
     ,p_pds_information2              => p_pds_information2
     ,p_pds_information3              => p_pds_information3
     ,p_pds_information4              => p_pds_information4
     ,p_pds_information5              => p_pds_information5
     ,p_pds_information6              => p_pds_information6
     ,p_pds_information7              => p_pds_information7
     ,p_pds_information8              => p_pds_information8
     ,p_pds_information9              => p_pds_information9
     ,p_pds_information10             => p_pds_information10
     ,p_pds_information11             => p_pds_information11
     ,p_pds_information12             => p_pds_information12
     ,p_pds_information13             => p_pds_information13
     ,p_pds_information14             => p_pds_information14
     ,p_pds_information15             => p_pds_information15
     ,p_pds_information16             => p_pds_information16
     ,p_pds_information17             => p_pds_information17
     ,p_pds_information18             => p_pds_information18
     ,p_pds_information19             => p_pds_information19
     ,p_pds_information20             => p_pds_information20
     ,p_pds_information21             => p_pds_information21
     ,p_pds_information22             => p_pds_information22
     ,p_pds_information23             => p_pds_information23
     ,p_pds_information24             => p_pds_information24
     ,p_pds_information25             => p_pds_information25
     ,p_pds_information26             => p_pds_information26
     ,p_pds_information27             => p_pds_information27
     ,p_pds_information28             => p_pds_information28
     ,p_pds_information29             => p_pds_information29
     ,p_pds_information30             => p_pds_information30
     ,p_object_version_number         => p_object_version_number
     );

Line: 366


         (p_module_name       => 'UPDATE_PDS_DETAILS',
          p_hook_type         => 'BP'
         );

Line: 473


       hr_utility.set_location('Update_pds_details ',800);

Line: 482


         hr_utility.set_location('Update_pds_details ',810);

Line: 491


            hr_utility.set_location('Update_pds_details ',812);

Line: 497


         hr_utility.set_location('Update_pds_details ',818);

Line: 503


           hr_utility.set_location('Update_pds_details ',820);

Line: 509


                 hr_utility.set_location('Update_pds_details ',900);

Line: 527


                 hr_utility.set_location('Update_pds_details ',910);

Line: 536


                 ,p_datetrack_delete_mode  => 'ZAP');

Line: 557


              hr_utility.set_location('Update PER Details ',920);

Line: 602


   hr_periods_of_service_bk1.update_pds_details_a
     (p_effective_date                =>  p_effective_date
     ,p_period_of_service_id          =>  p_period_of_service_id
     ,p_object_version_number         =>  p_object_version_number
     ,p_termination_accepted_person   =>  p_termination_accepted_person
     ,p_accepted_termination_date     =>  p_accepted_termination_date
     ,p_comments                      =>  p_comments
     ,p_leaving_reason                =>  p_leaving_reason
     ,p_notified_termination_date     =>  p_notified_termination_date
     ,p_projected_termination_date    =>  p_projected_termination_date
     ,p_actual_termination_date       => p_actual_termination_date
     ,p_last_standard_process_date    => p_last_standard_process_date
     ,p_final_process_date            => p_final_process_date
     ,p_attribute_category            =>  p_attribute_category
     ,p_attribute1                    =>  p_attribute1
     ,p_attribute2                    =>  p_attribute2
     ,p_attribute3                    =>  p_attribute3
     ,p_attribute4                    =>  p_attribute4
     ,p_attribute5                    =>  p_attribute5
     ,p_attribute6                    =>  p_attribute6
     ,p_attribute7                    =>  p_attribute7
     ,p_attribute8                    =>  p_attribute8
     ,p_attribute9                    =>  p_attribute9
     ,p_attribute10                   =>  p_attribute10
     ,p_attribute11                   =>  p_attribute11
     ,p_attribute12                   =>  p_attribute12
     ,p_attribute13                   =>  p_attribute13
     ,p_attribute14                   =>  p_attribute14
     ,p_attribute15                   =>  p_attribute15
     ,p_attribute16                   =>  p_attribute16
     ,p_attribute17                   =>  p_attribute17
     ,p_attribute18                   =>  p_attribute18
     ,p_attribute19                   =>  p_attribute19
     ,p_attribute20                   =>  p_attribute20
     ,p_pds_information_category      => p_pds_information_category
     ,p_pds_information1              => p_pds_information1
     ,p_pds_information2              => p_pds_information2
     ,p_pds_information3              => p_pds_information3
     ,p_pds_information4              => p_pds_information4
     ,p_pds_information5              => p_pds_information5
     ,p_pds_information6              => p_pds_information6
     ,p_pds_information7              => p_pds_information7
     ,p_pds_information8              => p_pds_information8
     ,p_pds_information9              => p_pds_information9
     ,p_pds_information10             => p_pds_information10
     ,p_pds_information11             => p_pds_information11
     ,p_pds_information12             => p_pds_information12
     ,p_pds_information13             => p_pds_information13
     ,p_pds_information14             => p_pds_information14
     ,p_pds_information15             => p_pds_information15
     ,p_pds_information16             => p_pds_information16
     ,p_pds_information17             => p_pds_information17
     ,p_pds_information18             => p_pds_information18
     ,p_pds_information19             => p_pds_information19
     ,p_pds_information20             => p_pds_information20
     ,p_pds_information21             => p_pds_information21
     ,p_pds_information22             => p_pds_information22
     ,p_pds_information23             => p_pds_information23
     ,p_pds_information24             => p_pds_information24
     ,p_pds_information25             => p_pds_information25
     ,p_pds_information26             => p_pds_information26
     ,p_pds_information27             => p_pds_information27
     ,p_pds_information28             => p_pds_information28
     ,p_pds_information29             => p_pds_information29
     ,p_pds_information30             => p_pds_information30
    );

Line: 671


         (p_module_name       => 'UPDATE_PDS_DETAILS',
          p_hook_type         => 'AP'
         );

Line: 688


    ROLLBACK TO update_pds_details;

Line: 702


    ROLLBACK TO update_pds_details;

Line: 711


end update_pds_details;

Line: 776


    SELECT NULL
    FROM   pay_payroll_actions ppa
          ,pay_assignment_actions paa
          ,per_assignments_f asg
          ,per_periods_of_service pds
    WHERE pds.period_of_service_id = p_period_of_service_id
    AND   pds.person_id = asg.person_id
    AND   asg.period_of_service_id = pds.period_of_service_id
    AND   asg.assignment_id = paa.assignment_id
    AND   paa.payroll_action_id = ppa.payroll_action_id
    AND   ppa.action_type NOT IN ('X','BEE')
    AND   ppa.effective_date > p_new_final_process_date;

Line: 795


    SELECT asg.assignment_id
          ,asg.effective_start_date
          ,asg.effective_end_date
          ,asg.object_version_number
          ,pds.actual_termination_date
    FROM   per_assignments_f asg
          ,per_periods_of_service pds
    WHERE pds.period_of_service_id = p_period_of_service_id
    AND   pds.person_id = asg.person_id
    AND   pds.period_of_service_id = asg.period_of_service_id
    AND   asg.effective_end_date = p_old_final_process_date;

Line: 824


    SELECT asg.object_version_number
    FROM   per_assignments_f asg
    WHERE  asg.assignment_id = csr_asg_ovn.p_assignment_id
    AND    csr_asg_ovn.p_effective_date BETWEEN asg.effective_start_date
                                            AND asg.effective_end_date;

Line: 836


  SELECT NULL
  FROM per_assignments_f asg
      ,per_periods_of_service pds
  WHERE pds.period_of_service_id = p_period_of_service_id
  AND   pds.period_of_service_id = asg.period_of_service_id
  AND   pds.person_id = asg.person_id
  AND   asg.effective_end_date = p_old_final_process_date;

Line: 845


  SELECT NULL
  FROM   pay_cost_allocations_f csa
  WHERE  csa.assignment_id = csr_lock_csa.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 851


  SELECT NULL
  FROM   pay_assignment_link_usages_f alu
  WHERE  alu.assignment_id = csr_lock_alu.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 857


  SELECT NULL
  FROM   pay_element_entries_f ele
  WHERE  ele.assignment_id = csr_lock_ele.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 863


  SELECT eev.element_entry_id
  FROM   pay_element_entry_values_f eev,
         pay_element_entries_f ele
  WHERE  ele.assignment_id    = p_assignment_id
  AND    eev.element_entry_id = ele.element_entry_id
  FOR    UPDATE NOWAIT;

Line: 871


  SELECT NULL
  FROM   per_spinal_point_placements_f spp
  WHERE  spp.assignment_id = csr_lock_spp.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 877


  SELECT NULL
  FROM   pay_personal_payment_methods_f ppm
  WHERE  ppm.assignment_id = csr_lock_ppm.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 883


  SELECT NULL
  FROM   per_secondary_ass_statuses sas
  WHERE  sas.assignment_id = csr_lock_sas.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 889


  SELECT NULL
  FROM   per_pay_proposals pyp
  WHERE  pyp.assignment_id = csr_lock_pyp.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 895


  SELECT asa.assignment_action_id
  FROM   pay_assignment_actions asa
  WHERE  asa.assignment_id = csr_lock_asa.p_assignment_id
  FOR    UPDATE NOWAIT;

Line: 901


  SELECT assignment_budget_value_id
  FROM   per_assignment_budget_values_f
  WHERE  assignment_id = csr_lock_abv.p_assignment_id
  AND    p_new_final_process_date BETWEEN effective_start_date
                                  AND     effective_end_date
  FOR    UPDATE NOWAIT;

Line: 1067


      UPDATE per_assignments_f
      SET effective_end_date = l_new_final_process_date
      WHERE assignment_id = l_assignment_id
      AND effective_start_date = l_effective_start_date
      AND effective_end_date = l_effective_end_date
      AND object_version_number = l_object_version_number;

Line: 1074


      UPDATE pay_cost_allocations_f
      SET    effective_end_date = l_new_final_process_date
      WHERE  assignment_id = l_assignment_id
      AND    p_old_final_process_date BETWEEN effective_start_date
                                          AND effective_end_date;

Line: 1080


      UPDATE per_spinal_point_placements_f
      SET    effective_end_date = l_new_final_process_date
      WHERE  assignment_id = l_assignment_id
      AND    p_old_final_process_date BETWEEN effective_start_date
                                          AND effective_end_date;

Line: 1086


      UPDATE per_assignment_budget_values_f
      SET    effective_end_date = l_new_final_process_date
      WHERE  assignment_id = l_assignment_id
      AND    p_old_final_process_date BETWEEN effective_start_date
                                          AND effective_end_date;

Line: 1092


      UPDATE pay_assignment_link_usages_f
      SET    effective_end_date = l_new_final_process_date
      WHERE  assignment_id = l_assignment_id
      AND    p_old_final_process_date BETWEEN effective_start_date
                                          AND effective_end_date;

Line: 1098


      UPDATE pay_assignment_actions
      SET    end_date = l_new_final_process_date
      WHERE  assignment_id = l_assignment_id
      AND    p_old_final_process_date BETWEEN start_date
                                          AND end_date;

Line: 1135


      UPDATE pay_personal_payment_methods_f ppm
      SET    effective_end_date = l_new_final_process_date
      WHERE  assignment_id = l_assignment_id
      AND    p_old_final_process_date BETWEEN effective_start_date
                                          AND effective_end_date;

Line: 1141


      UPDATE per_secondary_ass_statuses
      SET    end_date = l_new_final_process_date
      WHERE  assignment_id = l_assignment_id
      AND    NVL(end_date,p_old_final_process_date) = p_old_final_process_date;