APPS.IGS_PR_GEN_002 dependencies on IGS_AD_ADM_UNIT_STAT

Line 737: v_effective_progression_ind IGS_AD_ADM_UNIT_STAT.effective_progression_ind%TYPE;

733: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
734: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
735: v_finalised_ind VARCHAR2(1);
736: v_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
737: v_effective_progression_ind IGS_AD_ADM_UNIT_STAT.effective_progression_ind%TYPE;
738:
739: --
740: -- kdande; 22-Apr-2003; Bug# 2829262
741: -- Added uoo_id field to the SELECT clause of cursor c_sua.

Line 752: FROM IGS_AD_ADM_UNIT_STAT

748: sua.uoo_id = p_uoo_id;
749: CURSOR c_aus (
750: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
751: SELECT effective_progression_ind
752: FROM IGS_AD_ADM_UNIT_STAT
753: WHERE administrative_unit_status=cp_administrative_unit_status;
754: BEGIN
755: OPEN c_sua;
756: FETCH c_sua INTO v_unit_attempt_status,v_administrative_unit_status;