DBA Data[Home] [Help]

APPS.BEN_BCM_SHD SQL Statements

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

Line: 48

    select
       cwb_matrix_id
      ,name
      ,date_saved
      ,plan_id
      ,matrix_typ_cd
      ,person_id
      ,row_crit_cd
      ,col_crit_cd
      ,alct_by_cd
      ,business_group_id
      ,object_version_number
    from        ben_cwb_matrix
    where       cwb_matrix_id = p_cwb_matrix_id;
Line: 124

    select
       cwb_matrix_id
      ,name
      ,date_saved
      ,plan_id
      ,matrix_typ_cd
      ,person_id
      ,row_crit_cd
      ,col_crit_cd
      ,alct_by_cd
      ,business_group_id
      ,object_version_number
    from        ben_cwb_matrix
    where       cwb_matrix_id = p_cwb_matrix_id
    for update nowait;