[Home] [Help]
View: IGS_SV_ADD_DEP_DUM_V
Product: | IGS - Student System (Obsolete) |
Description: | Dummy view for the add dependent information block for XML message |
Implementation/DBA Data: |
Not implemented in this database
|
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