APPS.IGS_EN_SEVIS dependencies on HZ_PARTIES

Line 38: CURSOR c_authorisation_exists (cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

34: AND person_id = p_person_id
35: AND NVL(end_date, SYSDATE) >= SYSDATE;
36:
37: -- Cursor to check whether authorisation exists or not.
38: CURSOR c_authorisation_exists (cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
39: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
40: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
41: SELECT 'X' FROM igs_en_svs_auth esa
42: WHERE person_id = cp_person_id

Line 106: CURSOR c_sca (l_person_id hz_parties.party_id%TYPE) IS

102: AND sac.ci_sequence_number = l_sequence_number;
103:
104:
105: -- Cursor to get the course code for the authorised persons
106: CURSOR c_sca (l_person_id hz_parties.party_id%TYPE) IS
107: SELECT course_cd
108: FROM igs_en_stdnt_ps_att
109: WHERE person_id = l_person_id;
110:

Line 112: CURSOR c_person_name (l_person_id hz_parties.party_id%TYPE) IS

108: FROM igs_en_stdnt_ps_att
109: WHERE person_id = l_person_id;
110:
111: -- Get person related details
112: CURSOR c_person_name (l_person_id hz_parties.party_id%TYPE) IS
113: SELECT party_number, person_first_name||' '||person_middle_name||' '||person_last_name full_name
114: FROM hz_parties
115: WHERE party_id = l_person_id;
116:

Line 114: FROM hz_parties

110:
111: -- Get person related details
112: CURSOR c_person_name (l_person_id hz_parties.party_id%TYPE) IS
113: SELECT party_number, person_first_name||' '||person_middle_name||' '||person_last_name full_name
114: FROM hz_parties
115: WHERE party_id = l_person_id;
116:
117: CURSOR c_cal_type(l_cal_type igs_ca_inst_all.cal_type%TYPE, l_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
118: SELECT alternate_code, start_dt, end_dt

Line 137: CURSOR c_api_person(l_person_id hz_parties.party_id%TYPE) IS

133: WHERE lookup_type = 'IGS_EN_SEVIS_AUTH_CODES'
134: AND lookup_code = l_lookup_code;
135:
136: -- Get the preferred alternate person id
137: CURSOR c_api_person(l_person_id hz_parties.party_id%TYPE) IS
138: SELECT api_person_id
139: FROM igs_pe_person_id_type_v
140: WHERE pe_person_id = l_person_id;
141:

Line 854: CURSOR c_chk_for_auth_rec_overlap (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

850:
851:
852: FUNCTION is_auth_records_overlap(p_person_id IN NUMBER) RETURN BOOLEAN IS
853:
854: CURSOR c_chk_for_auth_rec_overlap (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
855: SELECT 'x'
856: FROM igs_en_svs_auth F,
857: igs_en_svs_auth S
858: WHERE f.person_id =cp_person_id