SQL Generator To Delete EMPLIDs

 SELECT 

 'DELETE ' || 
  CASE WHEN D.SQLTABLENAME = ' ' THEN 'PS_' || D.RECNAME ELSE D.SQLTABLENAME END 
 || ' WHERE EMPLID = ''123'';'
  FROM  
   PSRECFIELDDB C 
  , PSRECDEFN D 

 WHERE 
    C.RECNAME = D.RECNAME 

   AND C.FIELDNAME = 'EMPLID'
   AND D.RECTYPE = 0 

   AND EXISTS ( 
 SELECT 'X' 
  FROM all_tables 
 WHERE OWNER = 'SYSADM' 
   AND NUM_ROWS > 0 
   AND (TABLE_NAME = 'PS_' || D.RECNAME 
    OR TABLE_NAME = D.SQLTABLENAME))

DELETE PS_ACAD_HISTORY WHERE EMPLID = '123';
DELETE PS_ADM_APP_CAR_SEQ WHERE EMPLID = '123';
DELETE PS_ACAD_STDNG_ACTN WHERE EMPLID = '123';
DELETE PS_ACAD_DEGR_HONS WHERE EMPLID = '123';
DELETE PS_ACAD_DEGR_PLAN WHERE EMPLID = '123';
--- more...