APPS.IGS_AD_UPD_INITIALISE dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 186: CURSOR c_check_units (cp_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,

182: l_encoded_message VARCHAR2(2000);
183: l_app_short_name VARCHAR2(10);
184: l_message_name VARCHAR2(100);
185:
186: CURSOR c_check_units (cp_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
187: cp_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE) IS
188: SELECT 'X'
189: FROM IGS_EN_SU_ATTEMPT_ALL
190: WHERE person_id = cp_person_id

Line 187: cp_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE) IS

183: l_app_short_name VARCHAR2(10);
184: l_message_name VARCHAR2(100);
185:
186: CURSOR c_check_units (cp_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
187: cp_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE) IS
188: SELECT 'X'
189: FROM IGS_EN_SU_ATTEMPT_ALL
190: WHERE person_id = cp_person_id
191: AND course_cd = cp_course_cd;

Line 189: FROM IGS_EN_SU_ATTEMPT_ALL

185:
186: CURSOR c_check_units (cp_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE,
187: cp_course_cd IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE) IS
188: SELECT 'X'
189: FROM IGS_EN_SU_ATTEMPT_ALL
190: WHERE person_id = cp_person_id
191: AND course_cd = cp_course_cd;
192:
193: l_check_units VARCHAR2(1);