CURSOR c1 IS
 SELECT * FROM(
 SELECT ROWNUM R,TEMP.* FROM(
 SELECT distinct CUSTOMER_ID,CUST_CHT_NAME,CUST_ENG_NAME,ORG_BU_CODE,SESSION_DATE,FB_ID FROM CCR.DPS_CRT_TXN_DTL  x
   WHERE  exists (
   SELECT 1 from CCR.CIF_ORG_CUST_INFO
   WHERE
   NVL(CUST_CHT_NAME,' ') = NVL(x.CUST_CHT_NAME,' ')
   AND NVL(CUST_ENG_NAME,' ') = NVL(x.CUST_ENG_NAME,' ')
   AND CUST_ID= x.CUSTOMER_ID
   AND bu_code = 'FB002' AND session_date = SESSION_DATE_IN)
   AND x.session_date = SESSION_DATE_IN and org_bu_code = 'FB002'
     ORDER BY CUSTOMER_ID ) TEMP
    ) WHERE R >= START_ROW AND R <= END_ROW
     ;