, to_char(prm.date_from, 'yyyy-mm-dd') date_from , to_char(prm.date_to, 'yyyy-mm-dd') date_to , (select count(*) from per_role_mapping_roles prmr where prm.role ...