SELECT DISTINCT PERS.BATCH_ID BATCH_ID , PERS.PERSON_ID PERSON_ID FROM IGS_SV_PERSONS PERS WHERE PERS.RECORD_STATUS = 'N' AND EXISTS ( SELECT 1 FROM IGS_SV_BTCH_SUMMARY DEPSUMM WHERE PERS.PERSON_ID = DEPSUMM.PERSON_ID AND PERS.BATCH_ID = DEPSUMM.BATCH_ID AND DEPSUMM.TAG_CODE = 'SV_DEPDNT' AND DEPSUMM.ADM_ACTION_CODE = 'SEND' )