APPS.PER_US_EXTRA_REHIRE_RULES SQL Statements

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

Line: 3

PROCEDURE delete_tax_record
  (p_final_process_date    in date
  ,p_period_of_service_id  in number) IS
--
  CURSOR csr_get_address_id (p_pds_id NUMBER) IS
    SELECT adr.address_id
    FROM   per_addresses          adr,
           per_periods_of_service pds
    WHERE  pds.period_of_service_id = p_pds_id
    AND    adr.primary_flag         = 'Y'
    AND    adr.person_id            = pds.person_id;

Line: 25

        ,p_datetrack_mode => 'DELETE'
        ,p_address_id     => l_address_id
        ,p_delete_routine => 'ASSIGNMENT'
        );