APPS.PAY_RANGE_API SQL Statements

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

Line: 62

procedure update_range
(  p_range_id                     in     number
  ,p_object_version_number        in out nocopy number
  ,p_range_table_id               in     number    default hr_api.g_number
  ,p_low_band                     in     number    default hr_api.g_number
  ,p_high_band                    in     number    default hr_api.g_number
  ,p_amount1                      in     number    default hr_api.g_number
  ,p_amount2                      in     number    default hr_api.g_number
  ,p_amount3                      in     number    default hr_api.g_number
  ,p_amount4                      in     number    default hr_api.g_number
  ,p_amount5                      in     number    default hr_api.g_number
  ,p_amount6                      in     number    default hr_api.g_number
  ,p_amount7                      in     number    default hr_api.g_number
  ,p_amount8                      in     number    default hr_api.g_number
  ,p_effective_start_date         in     date      default hr_api.g_date
  ,p_effective_end_date           in     date      default hr_api.g_date
)

IS

  l_object_version_number   number;

Line: 112

end update_range;

Line: 114

procedure delete_range
 ( p_range_id                             in     number
  ,p_object_version_number                in     number
  )

IS


BEGIN


pay_ran_del.del
(
 p_range_id                            => p_range_id
,p_OBJECT_VERSION_NUMBER               => p_object_version_number
);

Line: 132

end delete_range;