APPS.IGS_EN_GEN_002 dependencies on IGS_AD_APPL

Line 336: IGS_AD_APPL aa,

332: NVL(acai.adm_ci_sequence_number, aa.adm_ci_sequence_number) adm_ci_sequence_number,
333: acai.prpsd_commencement_dt prpsd_commencement_dt
334: FROM
335: IGS_AD_PS_APPL_INST acai,
336: IGS_AD_APPL aa,
337: IGS_CA_INST ci,
338: IGS_AD_PS_APPL aca,
339: IGS_PS_VER crv
340: WHERE acai.person_id = p_person_id AND

Line 357: FROM IGS_AD_APPL aa

353: v_acaiv_rec c_acaiv%ROWTYPE;
354:
355: CURSOR c_aa IS
356: SELECT aa.s_admission_process_type
357: FROM IGS_AD_APPL aa
358: WHERE person_id = p_person_id AND
359: admission_appl_number = p_adm_admission_appl_number;
360: v_aa_rec c_aa%ROWTYPE;
361: CURSOR c_scae_cir_ci_cat IS