APPS.HR_LEAVING_REASON_MIG SQL Statements

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

Line: 36

     select pos.period_of_service_id , pos.object_version_number
     from   per_periods_of_service pos
     where  pos.leaving_reason = p_existing_leaving_reason
     order  by pos.period_of_service_id;

Line: 61

       hr_periods_of_service_api.update_pds_details(
        p_effective_date        => l_effective_date
       ,p_period_of_service_id  => pds_rec.period_of_service_id
       ,p_object_version_number => l_object_version_number
       ,p_leaving_reason	=> p_seeded_leaving_reason
       );

Line: 83

    Update fnd_lookup_values
    set end_date_active = l_effective_date, enabled_flag = 'N'
    where lookup_type = 'LEAV_REAS'
    and lookup_code = p_existing_leaving_reason;

Line: 88

  hr_utility.set_location('Updated lookup table : FND_LOOKUP_VALUES', 60);

Line: 96

 	  per_za_utility_pkg.za_term_cat_update(
 	  p_existing_leaving_reason =>  p_existing_leaving_reason
 	 ,p_seeded_leaving_reason   =>  p_seeded_leaving_reason
         );