APPS.GHR_WF SQL Statements

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

Line: 17

SELECT * FROM WF_ROLES
WHERE NAME =p_role;

Line: 22

SELECT *
 FROM ben_ext_rslt
 WHERE ext_rslt_id= p_result_id
   AND request_id = p_request_id;

Line: 30

SELECT DISTINCT (bed.name)
  FROM ben_ext_dfn bed
 WHERE bed.ext_dfn_id=cp_ext_dfn_id;

Line: 38

SELECT count(rslt.ext_rslt_id) rec_cnt
       FROM ben_ext_rcd_in_file rin
           ,ben_ext_dfn dfn
           ,ben_ext_rslt_dtl rslt
      WHERE dfn.ext_dfn_id   = cp_dfn_id
        AND rin.ext_file_id  = dfn.ext_file_id
        AND rin.hide_flag    = 'N'
        AND rin.ext_rcd_id   = rslt.EXT_RCD_ID
        and rslt.ext_rslt_id =cp_rslt_id;

Line: 79

 SELECT ghr_nfc_notif_seq_s.nextval
   INTO l_get_seq
  FROM  dual;

Line: 204

SELECT COUNT(*)
  FROM WF_USER_ROLE_ASSIGNMENTS_V wur
WHERE wur.role_name =cp_role;