APPS.IGS_EN_GET_SUAEH_DTL dependencies on USER_TAB_COLUMNS

Line 28: CURSOR c_sua ( cp_column_name user_tab_columns.column_name%TYPE,

24: gv_other_detail VARCHAR2(255);
25: BEGIN
26: DECLARE
27: -- cursor to get the current student unit attempt status
28: CURSOR c_sua ( cp_column_name user_tab_columns.column_name%TYPE,
29: cp_person_id igs_en_su_attempt.person_id%TYPE,
30: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
31: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
32: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */

Line 60: cp_column_name user_tab_columns.column_name%TYPE,

56: course_cd = cp_course_cd AND
57: uoo_id = cp_uoo_id;
58: -- cursor to get the last enrolled history
59: CURSOR c_last_e_suah (
60: cp_column_name user_tab_columns.column_name%TYPE,
61: cp_person_id igs_en_su_attempt_h.person_id%TYPE,
62: cp_course_cd igs_en_su_attempt_h.course_cd%TYPE,
63: cp_uoo_id igs_en_su_attempt_h.uoo_id%TYPE) IS
64: SELECT /*+ FIRST_ROWS */