Number of rows in a given PS table

SELECT TABLE_NAME,NUM_ROWS FROM ALL_TABLES WHERE SUBSTR(TABLE_NAME,4,LENGTH(TABLE_NAME)) IN (select A.RECNAME from psrecfielddb A , PSRECDEFN B where A.fieldname='PROFILE_CM_SEQ' AND B.RECTYPE=0 AND A.RECNAME=B.RECNAME)