[Home] [Help]
VIEW: APPS.IGS_SV_EV_AU_DEP_DUM_V
Source
View Text - Preformatted
SELECT distinct pers.batch_id batch_id, pers.person_id person_id FROM igs_sv_depdnt_info pers WHERE pers.depdnt_action_type = 'A'
View Text - HTML Formatted
SELECT DISTINCT PERS.BATCH_ID BATCH_ID
, PERS.PERSON_ID PERSON_ID
FROM IGS_SV_DEPDNT_INFO PERS
WHERE PERS.DEPDNT_ACTION_TYPE = 'A'