APPS.IGS_AS_GEN_003 dependencies on IGS_AS_UNIT_CLASS

Line 122: IGS_AS_UNIT_CLASS ucl,

118: SELECT sua.location_cd,
119: sua.exam_location_cd,
120: um.s_unit_mode
121: FROM IGS_EN_SU_ATTEMPT sua,
122: IGS_AS_UNIT_CLASS ucl,
123: IGS_AS_UNIT_MODE um
124: WHERE sua.person_id = p_person_id AND
125: sua.course_cd = p_course_cd AND
126: -- anilk, 22-Apr-2003, Bug# 2829262

Line 703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,

699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
705: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
706: RETURN VARCHAR2 IS
707: gv_other_detail VARCHAR2(1000);