APPS.IGS_ST_GEN_001 dependencies on IGS_PS_TYPE

Line 189: v_curr_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;

185: v_prev_sca_rec_found BOOLEAN DEFAULT FALSE;
186: v_exclusion_level VARCHAR2(15);
187: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
188: v_curr_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
189: v_curr_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
190: v_curr_responsible_org_unit_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
191: v_curr_course_level NUMBER;
192: v_prev_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
193: v_prev_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;

Line 193: v_prev_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;

189: v_curr_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
190: v_curr_responsible_org_unit_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
191: v_curr_course_level NUMBER;
192: v_prev_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
193: v_prev_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
194: v_prev_responsible_org_unit_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
195: v_prev_course_level NUMBER;
196: v_prev_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
197: v_prev_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 219: IGS_PS_TYPE cty

215: cp_course_cd,
216: cp_version_number,
217: cty.govt_course_type)
218: FROM IGS_PS_VER crv,
219: IGS_PS_TYPE cty
220: WHERE crv.course_cd = cp_course_cd AND
221: crv.version_number = cp_version_number AND
222: cty.course_type = crv.course_type;
223: CURSOR c_prev_sca(