SELECT * FROM 
(SELECT r.*, ROWNUM RNUM, COUNT(*) OVER () totalNumberOfRecords  FROM 
(
SELECT DISTINCT req.agcy_srvc_reqst_id reqId, req.SRVC_REQST_COR_RN refNo, req.reqstr_cd requesterCode, req.curr_reqst_status_cd requestStatusCode, req.inqrd_party_cd partyTypeCode,req.SRVC_TYPE_CD serviceTypeCode, req.PROCESS_TYPE_CD processTypeCode, req.BUS_SRVC_CD businessServiceTypeCode
 FROM agcy_srvc_reqst req 
 LEFT JOIN involved_party invparty ON invparty.agcy_srvc_reqst_id = req.agcy_srvc_reqst_id
 LEFT JOIN EXETR_SRVC_TASK exter ON req.agcy_srvc_reqst_id = exter.agcy_srvc_reqst_id
 LEFT JOIN SAFE_INFO_RESP safeInfoResp ON safeInfoResp.EXETR_SRVC_TASK_ID = exter.exetr_srvc_task_id
 LEFT JOIN PRD_USR_LST prdusr ON prdusr.PRD_ID = safeInfoResp.SAFE_INFO_RESP_ID
 WHERE 1=1 AND req.SRVC_REQST_COR_RN = ?  AND req.reqstr_cd = ? ) R) WHERE RNUM between ?  and ?