APPS.IGS_EN_SEVIS dependencies on IGS_EN_SVS_AUTH_CAL

Line 45: from igs_en_svs_auth_cal sac

41: SELECT 'X' FROM igs_en_svs_auth esa
42: WHERE person_id = cp_person_id
43: AND NVL(esa.end_dt, SYSDATE) >= SYSDATE
44: AND exists (select 'x'
45: from igs_en_svs_auth_cal sac
46: where sac.sevis_auth_id = esa.sevis_auth_id
47: and cal_type = cp_cal_type
48: and ci_sequence_number = cp_ci_sequence_number);
49:

Line 99: igs_en_svs_auth_cal sac

95: -- Cursor to get the authorized persons for the passed calander.
96: CURSOR c_auth_person(l_cal_type igs_ca_inst_all.cal_type%TYPE, l_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
97: SELECT person_id, SEVIS_AUTHORIZATION_CODE
98: FROM igs_en_svs_auth auth,
99: igs_en_svs_auth_cal sac
100: WHERE auth.sevis_auth_id = sac.sevis_auth_id
101: AND sac.cal_type = l_cal_type
102: AND sac.ci_sequence_number = l_sequence_number;
103:

Line 616: FROM IGS_EN_SVS_AUTH_CAL

612: p_ci_sequence_number IN NUMBER) AS
613:
614: CURSOR c_auth_cal_exists IS
615: SELECT 'X'
616: FROM IGS_EN_SVS_AUTH_CAL
617: WHERE SEVIS_AUTH_ID = p_sevis_auth_id
618: AND cal_type = p_cal_type
619: AND ci_sequence_number = p_ci_sequence_number;
620:

Line 635: igs_en_svs_auth_cal_pkg.insert_row (

631: RETURN;
632:
633: ELSE
634: CLOSE c_auth_cal_exists;
635: igs_en_svs_auth_cal_pkg.insert_row (
636: x_mode => 'R',
637: x_rowid => lv_rowid,
638: x_sevis_auth_id => p_sevis_auth_id,
639: x_cal_type => p_cal_type,