[Home] [Help]
VIEW: APPS.IGS_SV_EV_MATRIC_BLK_V
Source
View Text - Preformatted
SELECT prgm.batch_id batch_id, prgm.person_id person_id, prgm.matriculation matriculation, prgm.PRGM_END_DATE FROM igs_sv_prgms_info prgm WHERE prgm.prgm_action_type = 'EM'
View Text - HTML Formatted
SELECT PRGM.BATCH_ID BATCH_ID
, PRGM.PERSON_ID PERSON_ID
, PRGM.MATRICULATION MATRICULATION
, PRGM.PRGM_END_DATE
FROM IGS_SV_PRGMS_INFO PRGM
WHERE PRGM.PRGM_ACTION_TYPE = 'EM'