APPS.IGS_ST_GEN_003 dependencies on IGS_PS_UNIT_VER

Line 247: v_enr_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

243: v_resp_ou_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
244: v_resp_ou_start_dt IGS_PS_VER.responsible_ou_start_dt%TYPE;
245: v_govt_crs_type IGS_PS_TYPE.govt_course_type%TYPE;
246: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
247: v_enr_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
248: v_message_name_temp VARCHAR2(30) DEFAULT NULL;
249: v_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE DEFAULT NULL;
250: v_crs_req_cmplt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
251: v_comm_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 283: FROM IGS_PS_UNIT_VER uv

279: crv.version_number = p_crv_version_number AND
280: cty.course_type = crv.course_type;
281: CURSOR c_uv IS
282: SELECT uv.enrolled_credit_points
283: FROM IGS_PS_UNIT_VER uv
284: WHERE uv.unit_cd = p_unit_cd AND
285: uv.version_number = p_uv_version_number;
286: CURSOR c_sca IS
287: SELECT sca.fee_cat,