DBA Data[Home] [Help]

APPS.BEN_BCD_SHD SQL Statements

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

Line: 48

    select
       cwb_matrix_dtl_id
      ,cwb_matrix_id
      ,row_crit_val
      ,col_crit_val
      ,pct_emp_cndr
      ,pct_val
      ,emp_amt
      ,business_group_id
      ,object_version_number
    from        ben_cwb_matrix_dtl
    where       cwb_matrix_dtl_id = p_cwb_matrix_dtl_id;
Line: 122

    select
       cwb_matrix_dtl_id
      ,cwb_matrix_id
      ,row_crit_val
      ,col_crit_val
      ,pct_emp_cndr
      ,pct_val
      ,emp_amt
      ,business_group_id
      ,object_version_number
    from        ben_cwb_matrix_dtl
    where       cwb_matrix_dtl_id = p_cwb_matrix_dtl_id
    for update nowait;