APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_EN_SVS_AUTH

Line 3595: FROM igs_en_svs_auth

3591:
3592: CURSOR c_auth_details(cp_person_id igs_sv_prgms_info.person_id%TYPE)
3593: IS
3594: SELECT sevis_auth_id, sevis_authorization_code, start_dt, end_dt, comments, cancel_flag
3595: FROM igs_en_svs_auth
3596: WHERE person_id = cp_person_id;
3597:
3598: CURSOR c_prgm_dates(cp_person_id igs_sv_prgms_info.person_id%TYPE)
3599: IS

Line 3608: l_AUTH_CODE igs_en_svs_auth.sevis_authorization_code%TYPE;

3604:
3605:
3606:
3607: l_not_valid BOOLEAN := FALSE;
3608: l_AUTH_CODE igs_en_svs_auth.sevis_authorization_code%TYPE;
3609: l_AUTH_START_DT DATE;
3610: l_AUTH_END_DT DATE;
3611: l_COMMENTS VARCHAR2(500);
3612: l_visa_type VARCHAR2(5);