APPS.IGS_AD_GEN_002 dependencies on IGS_PS_DSCP

Line 1342: v_govt_discipline_group_cd IGS_PS_DSCP.govt_discipline_group_cd%TYPE;

1338: v_semester_enrolled NUMBER(1);
1339: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1340: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1341: v_subject_completion_code NUMBER(1);
1342: v_govt_discipline_group_cd IGS_PS_DSCP.govt_discipline_group_cd%TYPE;
1343: v_subject_discipline_group NUMBER(4);
1344: v_number_ind BOOLEAN;
1345: v_credit_points NUMBER(6);
1346: v_sua_eftsu NUMBER;

Line 1470: FROM IGS_PS_DSCP di,

1466: CURSOR c_di_ud (
1467: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
1468: cp_unit_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
1469: SELECT di.govt_discipline_group_cd
1470: FROM IGS_PS_DSCP di,
1471: IGS_PS_UNIT_DSCP ud
1472: WHERE di.discipline_group_cd = ud.discipline_group_cd AND
1473: ud.unit_cd = cp_unit_cd AND
1474: ud.version_number = cp_unit_version_number;