APPS.IGS_EN_VAL_SCA dependencies on IGS_AD_APPL

Line 101: FROM IGS_AD_APPL aa,

97: crv.course_type = cty.course_type;
98: v_aa_apcs_exists VARCHAR2(1);
99: CURSOR c_aa_apcs IS
100: SELECT 'x'
101: FROM IGS_AD_APPL aa,
102: IGS_AD_PRCS_CAT_STEP apcs
103: WHERE aa.person_id = p_person_id AND
104: aa.admission_appl_number = p_acai_admission_appl_number AND
105: aa.admission_cat = apcs.admission_cat AND

Line 1103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

1099: -- IGS_EN_STDNT_PS_ATT and IGS_AD_PS_APPL_INST database triggers,
1100: -- and the pre-enrolment process.
1101: DECLARE
1102: v_s_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;
1103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1104: v_dummy VARCHAR2(1);
1105: CURSOR c_aa IS
1106: SELECT s_admission_process_type
1107: FROM IGS_AD_APPL

Line 1107: FROM IGS_AD_APPL

1103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1104: v_dummy VARCHAR2(1);
1105: CURSOR c_aa IS
1106: SELECT s_admission_process_type
1107: FROM IGS_AD_APPL
1108: WHERE person_id = p_person_id AND
1109: admission_appl_number = p_admission_appl_number;
1110: CURSOR c_aca_sct IS
1111: SELECT 'x'

Line 2200: cp_person_id IGS_AD_APPL.person_id%TYPE,

2196: daiv.ci_sequence_number = p_acad_ci_sequence_number AND
2197: secc.commencement_dt_alias = daiv.dt_alias AND
2198: secc.s_control_num = 1;
2199: CURSOR c_aa (
2200: cp_person_id IGS_AD_APPL.person_id%TYPE,
2201: cp_adm_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
2202: SELECT aa.s_admission_process_type
2203: FROM IGS_AD_APPL aa
2204: WHERE aa.person_id = cp_person_id AND

Line 2201: cp_adm_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS

2197: secc.commencement_dt_alias = daiv.dt_alias AND
2198: secc.s_control_num = 1;
2199: CURSOR c_aa (
2200: cp_person_id IGS_AD_APPL.person_id%TYPE,
2201: cp_adm_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
2202: SELECT aa.s_admission_process_type
2203: FROM IGS_AD_APPL aa
2204: WHERE aa.person_id = cp_person_id AND
2205: aa.admission_appl_number = cp_adm_admission_appl_number;

Line 2203: FROM IGS_AD_APPL aa

2199: CURSOR c_aa (
2200: cp_person_id IGS_AD_APPL.person_id%TYPE,
2201: cp_adm_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
2202: SELECT aa.s_admission_process_type
2203: FROM IGS_AD_APPL aa
2204: WHERE aa.person_id = cp_person_id AND
2205: aa.admission_appl_number = cp_adm_admission_appl_number;
2206: v_aa_rec c_aa%ROWTYPE;
2207: CURSOR c_sua_ci IS