APPS.IGS_AD_GEN_002 dependencies on IGS_PE_COURSE_EXCL

Line 1296: cst_exc_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=

1292: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
1293: 'DISCONTIN';
1294: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
1295: 'COMPLETED';
1296: cst_exc_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=
1297: 'EXC_COURSE';
1298: cst_exc_crs_gp CONSTANT IGS_PE_CRS_GRP_EXCL.s_encmb_effect_type%TYPE :=
1299: 'EXC_CRS_GP';
1300: cst_sus_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=

Line 1300: cst_sus_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=

1296: cst_exc_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=
1297: 'EXC_COURSE';
1298: cst_exc_crs_gp CONSTANT IGS_PE_CRS_GRP_EXCL.s_encmb_effect_type%TYPE :=
1299: 'EXC_CRS_GP';
1300: cst_sus_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=
1301: 'SUS_COURSE';
1302: cst_academic CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'ACADEMIC';
1303: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';
1304: cst_student_rec_type CONSTANT VARCHAR2(1) := 'M';

Line 1331: v_s_encmb_effect_type IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE;

1327: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
1328: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
1329: v_honours_flag IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE;
1330: v_exclusion_flag VARCHAR2(1);
1331: v_s_encmb_effect_type IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE;
1332: v_course_completed_flag VARCHAR2(1);
1333: v_all_subjects_inc_flag VARCHAR2(1);
1334: v_subject_code IGS_PS_UNIT_VER.unit_cd%TYPE;
1335: v_subject_title IGS_PS_UNIT_VER.title%TYPE;

Line 1425: FROM IGS_PE_COURSE_EXCL pce

1421: CURSOR c_pce (
1422: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1423: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1424: SELECT pce.s_encmb_effect_type
1425: FROM IGS_PE_COURSE_EXCL pce
1426: WHERE pce.person_id = cp_person_id AND
1427: pce.s_encmb_effect_type IN (
1428: cst_exc_course,
1429: cst_sus_course) AND