SELECT dt.table_name, dat.ref_column_val, dat.perm_id, dat.perm_value
  FROM user_roles ur,
       ROLES ro,
       data_permissions dat,
       data_tables dt,
       control_objects co,
       page_control_objects pco,
       application_pages ap
 WHERE ro.role_id = ur.role_id
   AND ro.role_id = dat.role_id
   AND dt.dt_id = dat.dt_id
   AND co.obj_id = dt.obj_id
   AND co.obj_id = pco.obj_id
   AND ap.page_id = pco.page_id
   AND co.app_id = ro.app_id
   AND ap.app_id = ro.app_id
   AND ur.user_id = :USER_ID
   AND ro.app_id = :APP_ID
   AND ap.PAGE_NAME = :PAGE_NAME
   AND ro.IS_ROLE_VARIATION = 'Y'	   
   
   