VIEW: APPS.IGS_SV_EV_DEL_DPD_BLK_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'