VIEW: APPS.IGS_SV_UPD_DROP_BLW_V

Source

View Text - Preformatted

SELECT prgms_new.batch_id, prgms_new.person_id, prgms_new.print_form, prgms_new.authorization_reason new_auth_reason, prgms_new.prgm_start_date new_auth_start_date, prgms_new.prgm_end_date new_auth_end_date, prgms_new.remarks dbf_remarks, prgms_old.authorization_reason auth_reason, prgms_old.prgm_start_date auth_start_date, prgms_old.prgm_end_date auth_end_date, prgms_new.auth_action_code FROM igs_sv_prgms_info prgms_new, igs_sv_prgms_info prgms_old WHERE prgms_new.prgm_action_type = 'DB' AND prgms_new.auth_action_code = 'U' AND prgms_new.person_id = prgms_old.person_id and prgms_old.prgm_action_type = 'DB' AND prgms_old.sevis_auth_id = prgms_new.sevis_auth_id AND prgms_new.batch_id <> prgms_old.batch_id AND prgms_old.batch_id = (select max(batch_id) from igs_sv_prgms_info where person_id = prgms_new.person_id AND sevis_auth_id = prgms_new.sevis_auth_id AND batch_id < (select max(batch_id) from igs_sv_prgms_info WHERE person_id = prgms_new.person_id AND sevis_auth_id = prgms_new.sevis_auth_id))

View Text - HTML Formatted

SELECT PRGMS_NEW.BATCH_ID
, PRGMS_NEW.PERSON_ID
, PRGMS_NEW.PRINT_FORM
, PRGMS_NEW.AUTHORIZATION_REASON NEW_AUTH_REASON
, PRGMS_NEW.PRGM_START_DATE NEW_AUTH_START_DATE
, PRGMS_NEW.PRGM_END_DATE NEW_AUTH_END_DATE
, PRGMS_NEW.REMARKS DBF_REMARKS
, PRGMS_OLD.AUTHORIZATION_REASON AUTH_REASON
, PRGMS_OLD.PRGM_START_DATE AUTH_START_DATE
, PRGMS_OLD.PRGM_END_DATE AUTH_END_DATE
, PRGMS_NEW.AUTH_ACTION_CODE
FROM IGS_SV_PRGMS_INFO PRGMS_NEW
, IGS_SV_PRGMS_INFO PRGMS_OLD
WHERE PRGMS_NEW.PRGM_ACTION_TYPE = 'DB'
AND PRGMS_NEW.AUTH_ACTION_CODE = 'U'
AND PRGMS_NEW.PERSON_ID = PRGMS_OLD.PERSON_ID
AND PRGMS_OLD.PRGM_ACTION_TYPE = 'DB'
AND PRGMS_OLD.SEVIS_AUTH_ID = PRGMS_NEW.SEVIS_AUTH_ID
AND PRGMS_NEW.BATCH_ID <> PRGMS_OLD.BATCH_ID
AND PRGMS_OLD.BATCH_ID = (SELECT MAX(BATCH_ID)
FROM IGS_SV_PRGMS_INFO
WHERE PERSON_ID = PRGMS_NEW.PERSON_ID
AND SEVIS_AUTH_ID = PRGMS_NEW.SEVIS_AUTH_ID
AND BATCH_ID < (SELECT MAX(BATCH_ID)
FROM IGS_SV_PRGMS_INFO
WHERE PERSON_ID = PRGMS_NEW.PERSON_ID
AND SEVIS_AUTH_ID = PRGMS_NEW.SEVIS_AUTH_ID))