DBA Data[Home] [Help]

VIEW: APPS.IGS_SV_ACT_DPND_BLK_V

Source

View Text - Preformatted

SELECT dpdt.batch_id, dpdt.person_id, dpdt.print_form, dpdt.depdnt_id, NULL person_number, dpdt.depdnt_sevis_id, dpdt.remarks reactivate_dependent, NULL person_id_long FROM igs_sv_depdnt_info dpdt WHERE dpdt.depdnt_action_type = 'R'
View Text - HTML Formatted

SELECT DPDT.BATCH_ID
, DPDT.PERSON_ID
, DPDT.PRINT_FORM
, DPDT.DEPDNT_ID
, NULL PERSON_NUMBER
, DPDT.DEPDNT_SEVIS_ID
, DPDT.REMARKS REACTIVATE_DEPENDENT
, NULL PERSON_ID_LONG
FROM IGS_SV_DEPDNT_INFO DPDT
WHERE DPDT.DEPDNT_ACTION_TYPE = 'R'