APPS.IGS_EN_GEN_002 dependencies on IGS_AD_PS_APPL

Line 335: IGS_AD_PS_APPL_INST acai,

331: SELECT NVL(acai.adm_cal_type, aa.adm_cal_type) adm_cal_type,
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

Line 338: IGS_AD_PS_APPL aca,

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
341: aa.person_id = acai.person_id AND
342: acai.admission_appl_number = p_adm_admission_appl_number AND