APPS.IGS_AD_VAL_ACA dependencies on IGS_PS_VER

Line 234: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;

230: cst_discontin CONSTANT VARCHAR2(9) := 'DISCONTIN';
231: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
232: v_message_name VARCHAR2(30);
233: v_encmb_chk_dt IGS_CA_DA_INST_V.alias_val%TYPE;
234: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
235: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
237: v_transfer_course_group_found BOOLEAN DEFAULT FALSE;
238: v_nominated_course_found BOOLEAN DEFAULT FALSE;

Line 242: FROM IGS_PS_VER

238: v_nominated_course_found BOOLEAN DEFAULT FALSE;
239: v_check CHAR;
240: CURSOR c_cv IS
241: SELECT generic_course_ind
242: FROM IGS_PS_VER
243: WHERE course_cd = p_nominated_course_cd AND
244: version_number = p_nominated_version_number;
245: CURSOR c_sca IS
246: SELECT course_attempt_status,