APPS.PER_US_EXTRA_ASSIGNMENT_RULES SQL Statements

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

Line: 3

PROCEDURE insert_tax_record
  (p_effective_date    in date
  ,p_assignment_id     in number
  ) IS
  BEGIN
    pay_us_tax_internal.maintain_us_employee_taxes (
       p_effective_date => p_effective_date
      ,p_assignment_id  => p_assignment_id
      ,p_delete_routine => 'ASSIGNMENT'
      );

Line: 15

PROCEDURE update_tax_record
  (p_effective_date        in date
  ,p_datetrack_update_mode in varchar2
  ,p_assignment_id         in number
  ,p_location_id           in number
  ) IS
  BEGIN
    pay_us_tax_internal.maintain_us_employee_taxes (
       p_effective_date => p_effective_date
      ,p_datetrack_mode => p_datetrack_update_mode
      ,p_assignment_id  => p_assignment_id
      ,p_location_id    => p_location_id
      ,p_delete_routine => 'ASSIGNMENT'
      );

Line: 33

  ,p_datetrack_update_mode in varchar2
  ,p_assignment_id         in number
  ) IS
--
  cursor csr_asg_data is
    select asg.location_id
    from   per_assignments_f asg
    where  asg.assignment_id = p_assignment_id
    and    p_effective_date between asg.effective_start_date
           and asg.effective_end_date;

Line: 66

PROCEDURE delete_tax_record
  (p_final_process_date in date
  ,p_assignment_id      in number
  ) IS
  BEGIN
    pay_us_tax_internal.maintain_us_employee_taxes (
       p_effective_date => p_final_process_date
      ,p_datetrack_mode => 'DELETE'
      ,p_assignment_id  => p_assignment_id
      ,p_delete_routine => 'ASSIGNMENT'
      );