eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CPG_SHD SQL Statements

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

Line: 62


    select
       group_per_in_ler_id
      ,group_pl_id
      ,group_oipl_id
      ,lf_evt_ocrd_dt
      ,bdgt_pop_cd
      ,due_dt
      ,access_cd
      ,approval_cd
      ,approval_date
      ,approval_comments
      ,submit_cd
      ,submit_date
      ,submit_comments
      ,dist_bdgt_val
      ,ws_bdgt_val
      ,rsrv_val
      ,dist_bdgt_mn_val
      ,dist_bdgt_mx_val
      ,dist_bdgt_incr_val
      ,ws_bdgt_mn_val
      ,ws_bdgt_mx_val
      ,ws_bdgt_incr_val
      ,rsrv_mn_val
      ,rsrv_mx_val
      ,rsrv_incr_val
      ,dist_bdgt_iss_val
      ,ws_bdgt_iss_val
      ,dist_bdgt_iss_date
      ,ws_bdgt_iss_date
      ,ws_bdgt_val_last_upd_date
      ,dist_bdgt_val_last_upd_date
      ,rsrv_val_last_upd_date
      ,ws_bdgt_val_last_upd_by
      ,dist_bdgt_val_last_upd_by
      ,rsrv_val_last_upd_by
      ,object_version_number
    from        ben_cwb_person_groups
    where       group_per_in_ler_id = p_group_per_in_ler_id
    and   group_pl_id = p_group_pl_id
    and   group_oipl_id = p_group_oipl_id;

Line: 173


    select
       group_per_in_ler_id
      ,group_pl_id
      ,group_oipl_id
      ,lf_evt_ocrd_dt
      ,bdgt_pop_cd
      ,due_dt
      ,access_cd
      ,approval_cd
      ,approval_date
      ,approval_comments
      ,submit_cd
      ,submit_date
      ,submit_comments
      ,dist_bdgt_val
      ,ws_bdgt_val
      ,rsrv_val
      ,dist_bdgt_mn_val
      ,dist_bdgt_mx_val
      ,dist_bdgt_incr_val
      ,ws_bdgt_mn_val
      ,ws_bdgt_mx_val
      ,ws_bdgt_incr_val
      ,rsrv_mn_val
      ,rsrv_mx_val
      ,rsrv_incr_val
      ,dist_bdgt_iss_val
      ,ws_bdgt_iss_val
      ,dist_bdgt_iss_date
      ,ws_bdgt_iss_date
      ,ws_bdgt_val_last_upd_date
      ,dist_bdgt_val_last_upd_date
      ,rsrv_val_last_upd_date
      ,ws_bdgt_val_last_upd_by
      ,dist_bdgt_val_last_upd_by
      ,rsrv_val_last_upd_by
      ,object_version_number
    from        ben_cwb_person_groups
    where       group_per_in_ler_id = p_group_per_in_ler_id
    and   group_pl_id = p_group_pl_id
    and   group_oipl_id = p_group_oipl_id
    for update nowait;