APPS.IGS_EN_VAL_SUA dependencies on IGS_EN_GEN_003

Line 145: SELECT IGS_EN_GEN_003.Get_Staff_Ind( rsup.person_id) person_type

141: rsup.start_dt <= pl_check_dt AND
142: (rsup.end_dt IS NULL OR
143: rsup.end_dt >= pl_check_dt);
144: CURSOR c_rsup_per_type IS
145: SELECT IGS_EN_GEN_003.Get_Staff_Ind( rsup.person_id) person_type
146: FROM IGS_RE_SPRVSR rsup
147: WHERE rsup.ca_person_id = p_person_id AND
148: rsup.ca_sequence_number = pl_ca_sequence_number AND
149: rsup.start_dt <= pl_check_dt AND

Line 2736: l_enr_category := IGS_EN_GEN_003.enrp_get_enr_cat( p_person_id => p_person_id,

2732: p_ret_status => l_return_status);
2733:
2734: -- getting enrolment category , commencement type
2735:
2736: l_enr_category := IGS_EN_GEN_003.enrp_get_enr_cat( p_person_id => p_person_id,
2737: p_course_cd => p_course_cd,
2738: p_cal_type => p_cal_type,
2739: p_ci_sequence_number => p_ci_sequence_number ,
2740: p_session_enrolment_cat =>NULL,

Line 3777: l_enrolment_cat:=IGS_EN_GEN_003.Enrp_Get_Enr_Cat(p_person_id =>p_person_id,

3773: EXIT WHEN cur_sub_sua%NOTFOUND;
3774:
3775: -- Determine the Enrollment method , Enrollment Commencement type.
3776: l_dummy := NULL;
3777: l_enrolment_cat:=IGS_EN_GEN_003.Enrp_Get_Enr_Cat(p_person_id =>p_person_id,
3778: p_course_cd =>p_course_cd,
3779: p_cal_type =>p_acad_cal_type,
3780: p_ci_sequence_number =>p_acad_seq_num,
3781: p_session_enrolment_cat =>NULL,