View: IGS_SV_EV_DEL_DPD_BLK_V

Product:	IGS - Student System
Description:	View for fetching deleted dependents information
Implementation/DBA Data:	APPS.IGS_SV_EV_DEL_DPD_BLK_V

View Text

SELECT SVDI.BATCH_ID BATCH_ID
, SVDI.PERSON_ID PERSON_ID
, SVDI.DEPDNT_SEVIS_ID DEPDNT_SEVIS_ID
, SVDI.DEPDNT_ID DEPDNT_ID
FROM IGS_SV_DEPDNT_INFO SVDI
WHERE SVDI.DEPDNT_ACTION_TYPE = 'D'

Columns