APPS.IGS_IN_GEN_001 dependencies on IGS_PS_VER

Line 650: v_crv_credit_points_required IGS_PS_VER.credit_points_required%TYPE;

646: BEGIN -- func_module
647: DECLARE
648: cst_enrolled CONSTANT
649: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
650: v_crv_credit_points_required IGS_PS_VER.credit_points_required%TYPE;
651: v_enrolled_total NUMBER;
652: v_cp_required IGS_PS_VER.credit_points_required%TYPE;
653: v_cp_passed NUMBER;
654: v_adv_granted NUMBER;

Line 652: v_cp_required IGS_PS_VER.credit_points_required%TYPE;

648: cst_enrolled CONSTANT
649: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
650: v_crv_credit_points_required IGS_PS_VER.credit_points_required%TYPE;
651: v_enrolled_total NUMBER;
652: v_cp_required IGS_PS_VER.credit_points_required%TYPE;
653: v_cp_passed NUMBER;
654: v_adv_granted NUMBER;
655: v_cp_remaining NUMBER;
656: CURSOR c_crv IS

Line 658: FROM IGS_PS_VER crv

654: v_adv_granted NUMBER;
655: v_cp_remaining NUMBER;
656: CURSOR c_crv IS
657: SELECT crv.credit_points_required
658: FROM IGS_PS_VER crv
659: WHERE crv.course_cd = p_course_cd AND
660: crv.version_number = p_version_number;
661:
662: