APPS.BEN_UPDATE_PRTT_RT_VAL SQL Statements

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

Line: 30

    select element_entry_value_id
    from   pay_element_entry_values_f
    where  element_entry_id = p_element_entry_id
    and    input_value_id   = p_input_value_id
    and    p_effective_date between effective_start_date
    and    effective_end_date;

Line: 55

        ben_prtt_rt_val_api.update_prtt_rt_val
         (p_validate                => false
         ,p_prtt_rt_val_id          => l_prv.prtt_rt_val_id
         ,p_business_group_id       => l_prv.business_group_id
         ,p_element_entry_value_id  => l_element_entry_value_id
         ,p_object_version_number   => l_prv.object_version_number
         ,p_effective_date          => l_prv.rt_strt_dt
   );

Line: 68

end update_element_entry_value;