View: IGS_SV_ADD_DEP_DUM_V

Product:	IGS - Student System
Description:	Dummy view for the add dependent information block for XML message
Implementation/DBA Data:	APPS.IGS_SV_ADD_DEP_DUM_V

View Text

SELECT DISTINCT SVDI.PERSON_ID
, SVDI.BATCH_ID
FROM IGS_SV_DEPDNT_INFO SVDI
, IGS_SV_BTCH_SUMMARY DEPSUMM
WHERE SVDI.PERSON_ID = DEPSUMM.PERSON_ID
AND SVDI.BATCH_ID = DEPSUMM.BATCH_ID
AND DEPSUMM.TAG_CODE = 'SV_DEPDNT'
AND DEPSUMM.ADM_ACTION_CODE = 'SEND'

Columns