62:
63: END enrp_get_student_ind;
64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
81: gv_other_detail Varchar2(255);
82: BEGIN
83: DECLARE
84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS