APPS.IGS_GR_VAL_GR dependencies on IGS_EN_STDNT_PS_ATT

Line 114: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

110: BEGIN -- grdp_val_gr_sca
111: -- Validate the graduand record student course attempt is for a
112: -- course version that graduates students.
113: DECLARE
114: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
115: v_crv_exists VARCHAR2(1);
116: CURSOR c_sca IS
117: SELECT sca.version_number
118: FROM IGS_EN_STDNT_PS_ATT sca

Line 118: FROM IGS_EN_STDNT_PS_ATT sca

114: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
115: v_crv_exists VARCHAR2(1);
116: CURSOR c_sca IS
117: SELECT sca.version_number
118: FROM IGS_EN_STDNT_PS_ATT sca
119: WHERE sca.person_id = p_person_id AND
120: course_cd = p_course_cd;
121: CURSOR c_crv(
122: cp_version_number IGS_PS_VER.version_number%TYPE) IS

Line 1132: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

1128: RETURN BOOLEAN AS
1129: BEGIN -- grdp_val_aw_eligible
1130: -- Validate the graduand is academically eligible for the award.
1131: DECLARE
1132: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1133: v_sca_crs_rqrmnt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1134: CURSOR c_sca IS
1135: SELECT sca.version_number,
1136: sca.course_rqrmnt_complete_ind

Line 1133: v_sca_crs_rqrmnt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;

1129: BEGIN -- grdp_val_aw_eligible
1130: -- Validate the graduand is academically eligible for the award.
1131: DECLARE
1132: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1133: v_sca_crs_rqrmnt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1134: CURSOR c_sca IS
1135: SELECT sca.version_number,
1136: sca.course_rqrmnt_complete_ind
1137: FROM IGS_EN_STDNT_PS_ATT sca

Line 1137: FROM IGS_EN_STDNT_PS_ATT sca

1133: v_sca_crs_rqrmnt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
1134: CURSOR c_sca IS
1135: SELECT sca.version_number,
1136: sca.course_rqrmnt_complete_ind
1137: FROM IGS_EN_STDNT_PS_ATT sca
1138: WHERE sca.person_id = p_person_id AND
1139: sca.course_cd = p_course_cd;
1140: v_scaae_exists VARCHAR2(1);
1141: CURSOR c_scaae

Line 1142: (cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

1138: WHERE sca.person_id = p_person_id AND
1139: sca.course_cd = p_course_cd;
1140: v_scaae_exists VARCHAR2(1);
1141: CURSOR c_scaae
1142: (cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
1143: SELECT 'x'
1144: FROM IGS_PS_STDNT_APV_ALT scaae
1145: WHERE scaae.person_id = p_person_id AND
1146: scaae.course_cd = p_course_cd AND

Line 1229: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

1225: BEGIN -- grdp_val_gr_caw
1226: -- Validate the graduand record course award is an award for the
1227: -- student course attempt or an alternative exit.
1228: DECLARE
1229: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1230: v_ae_exists VARCHAR2(1);
1231: CURSOR c_sca IS
1232: SELECT sca.version_number
1233: FROM IGS_EN_STDNT_PS_ATT sca

Line 1233: FROM IGS_EN_STDNT_PS_ATT sca

1229: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1230: v_ae_exists VARCHAR2(1);
1231: CURSOR c_sca IS
1232: SELECT sca.version_number
1233: FROM IGS_EN_STDNT_PS_ATT sca
1234: WHERE sca.person_id = p_person_id AND
1235: course_cd = p_course_cd;
1236: CURSOR c_ae(
1237: cp_version_number IGS_PE_ALTERNATV_EXT.version_number%TYPE) IS

Line 1399: FROM IGS_EN_STDNT_PS_ATT sca

1395: FROM IGS_GR_STAT gst
1396: WHERE gst.graduand_status = p_graduand_status;
1397: CURSOR c_sca IS
1398: SELECT 'x'
1399: FROM IGS_EN_STDNT_PS_ATT sca
1400: WHERE sca.person_id = p_person_id AND
1401: sca.course_cd = p_sur_for_course_cd AND
1402: sca.version_number = p_sur_for_crs_version_num;
1403: BEGIN