APPS.BEN_RTS_SHD SQL Statements

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

Line: 62

    select
       person_rate_id
      ,group_per_in_ler_id
      ,pl_id
      ,oipl_id
      ,group_pl_id
      ,group_oipl_id
      ,lf_evt_ocrd_dt
      ,person_id
      ,assignment_id
      ,elig_flag
      ,ws_val
      ,ws_mn_val
      ,ws_mx_val
      ,ws_incr_val
      ,elig_sal_val
      ,stat_sal_val
      ,oth_comp_val
      ,tot_comp_val
      ,misc1_val
      ,misc2_val
      ,misc3_val
      ,rec_val
      ,rec_mn_val
      ,rec_mx_val
      ,rec_incr_val
      ,ws_val_last_upd_date
      ,ws_val_last_upd_by
      ,pay_proposal_id
      ,element_entry_value_id
      ,inelig_rsn_cd
      ,elig_ovrid_dt
      ,elig_ovrid_person_id
      ,copy_dist_bdgt_val
      ,copy_ws_bdgt_val
      ,copy_rsrv_val
      ,copy_dist_bdgt_mn_val
      ,copy_dist_bdgt_mx_val
      ,copy_dist_bdgt_incr_val
      ,copy_ws_bdgt_mn_val
      ,copy_ws_bdgt_mx_val
      ,copy_ws_bdgt_incr_val
      ,copy_rsrv_mn_val
      ,copy_rsrv_mx_val
      ,copy_rsrv_incr_val
      ,copy_dist_bdgt_iss_val
      ,copy_ws_bdgt_iss_val
      ,copy_dist_bdgt_iss_date
      ,copy_ws_bdgt_iss_date
      ,comp_posting_date
      ,ws_rt_start_date
      ,currency
      ,object_version_number
    from        ben_cwb_person_rates
    where       group_per_in_ler_id = p_group_per_in_ler_id
    and   pl_id = p_pl_id
    and   oipl_id = p_oipl_id;

Line: 189

    select
       person_rate_id
      ,group_per_in_ler_id
      ,pl_id
      ,oipl_id
      ,group_pl_id
      ,group_oipl_id
      ,lf_evt_ocrd_dt
      ,person_id
      ,assignment_id
      ,elig_flag
      ,ws_val
      ,ws_mn_val
      ,ws_mx_val
      ,ws_incr_val
      ,elig_sal_val
      ,stat_sal_val
      ,oth_comp_val
      ,tot_comp_val
      ,misc1_val
      ,misc2_val
      ,misc3_val
      ,rec_val
      ,rec_mn_val
      ,rec_mx_val
      ,rec_incr_val
      ,ws_val_last_upd_date
      ,ws_val_last_upd_by
      ,pay_proposal_id
      ,element_entry_value_id
      ,inelig_rsn_cd
      ,elig_ovrid_dt
      ,elig_ovrid_person_id
      ,copy_dist_bdgt_val
      ,copy_ws_bdgt_val
      ,copy_rsrv_val
      ,copy_dist_bdgt_mn_val
      ,copy_dist_bdgt_mx_val
      ,copy_dist_bdgt_incr_val
      ,copy_ws_bdgt_mn_val
      ,copy_ws_bdgt_mx_val
      ,copy_ws_bdgt_incr_val
      ,copy_rsrv_mn_val
      ,copy_rsrv_mx_val
      ,copy_rsrv_incr_val
      ,copy_dist_bdgt_iss_val
      ,copy_ws_bdgt_iss_val
      ,copy_dist_bdgt_iss_date
      ,copy_ws_bdgt_iss_date
      ,comp_posting_date
      ,ws_rt_start_date
      ,currency
      ,object_version_number
    from        ben_cwb_person_rates
    where       group_per_in_ler_id = p_group_per_in_ler_id
    and   pl_id = p_pl_id
    and   oipl_id = p_oipl_id
    for update nowait;