APPS.IGS_AD_GEN_002 dependencies on IGS_PE_CRS_GRP_EXCL

Line 1298: cst_exc_crs_gp CONSTANT IGS_PE_CRS_GRP_EXCL.s_encmb_effect_type%TYPE :=

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 :=
1301: 'SUS_COURSE';
1302: cst_academic CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'ACADEMIC';

Line 1435: FROM IGS_PE_CRS_GRP_EXCL pcge,

1431: CURSOR c_pcge_cgr_cgm (
1432: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1433: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1434: SELECT pcge.s_encmb_effect_type
1435: FROM IGS_PE_CRS_GRP_EXCL pcge,
1436: IGS_PS_GRP cgr,
1437: IGS_PS_GRP_MBR cgm
1438: WHERE pcge.person_id = cp_person_id AND
1439: pcge.s_encmb_effect_type = cst_exc_crs_gp AND