View used for adding Exchange Visitor dependent block for the header of the information. This is a dummy view used by the map.
Implementation/DBA Data:
Not implemented in this database
View Text
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' )