APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_EN_STDNT_PS_ATT

Line 529: FROM IGS_EN_STDNT_PS_ATT sca

525: -- confirmed. (AODS04)
526: DECLARE
527: CURSOR c_sca IS
528: SELECT 'x'
529: FROM IGS_EN_STDNT_PS_ATT sca
530: WHERE sca.person_id = p_person_id AND
531: NVL(sca.adm_nominated_course_cd, 'NULL') =
532: NVL(p_nominated_course_cd, 'NULL') AND
533: NVL(sca.adm_admission_appl_number, -1) = NVL(p_admission_appl_number, -1) AND

Line 1265: FROM IGS_EN_STDNT_PS_ATT sca

1261: -- (these are created via ENRF4150 ? course Transfer)
1262: DECLARE
1263: CURSOR c_sca_conf IS
1264: SELECT sca.course_attempt_status
1265: FROM IGS_EN_STDNT_PS_ATT sca
1266: WHERE sca.person_id = p_person_id AND
1267: sca.course_cd = p_course_cd AND
1268: sca.adm_admission_appl_number IS NOT NULL AND
1269: sca.adm_admission_appl_number = p_admission_appl_number AND

Line 1825: FROM IGS_EN_STDNT_PS_ATT sca

1821: v_message_name VARCHAR2(30);
1822: v_dummy VARCHAR2(1);
1823: CURSOR c_sca IS
1824: SELECT 'x'
1825: FROM IGS_EN_STDNT_PS_ATT sca
1826: WHERE sca.person_id = p_person_id AND
1827: sca.adm_admission_appl_number IS NOT NULL AND
1828: sca.adm_admission_appl_number = p_admission_appl_number AND
1829: sca.adm_nominated_course_cd IS NOT NULL AND

Line 2145: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

2141: v_reconsideratn_processing BOOLEAN ;
2142: v_message_name VARCHAR2(30);
2143: v_return_type VARCHAR2(1);
2144: v_late_ind VARCHAR2(1);
2145: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2146: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;
2147: v_effective_dt DATE;
2148: v_prpsd_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2149: v_ca_sequence_number NUMBER;

Line 2148: v_prpsd_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

2144: v_late_ind VARCHAR2(1);
2145: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2146: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;
2147: v_effective_dt DATE;
2148: v_prpsd_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2149: v_ca_sequence_number NUMBER;
2150: CURSOR c_aal IS
2151: SELECT 'x'
2152: FROM IGS_AD_APPL_LTR aal

Line 2178: FROM IGS_EN_STDNT_PS_ATT sca

2174: auos.s_adm_outcome_status = cst_pending AND
2175: acaiu.adm_unit_outcome_status = auos.adm_unit_outcome_status;
2176: CURSOR c_sca IS
2177: SELECT sca.course_attempt_status
2178: FROM IGS_EN_STDNT_PS_ATT sca
2179: WHERE sca.person_id = p_person_id AND
2180: sca.course_cd = p_course_cd AND
2181: sca.adm_admission_appl_number = p_admission_appl_number AND
2182: sca.adm_nominated_course_cd = p_nominated_course_cd AND