APPS.IGS_RE_GEN_002 dependencies on IGS_AD_PS_APPL_INST

Line 232: FROM IGS_AD_PS_APPL_INST acai

228: SELECT acai.course_cd,
229: acai.crv_version_number,
230: acai.adm_outcome_status,
231: acai.prpsd_commencement_dt
232: FROM IGS_AD_PS_APPL_INST acai
233: WHERE acai.person_id = p_person_id AND
234: acai.admission_appl_number = cp_adm_appl_number AND
235: acai.nominated_course_cd = cp_nom_course_cd AND
236: acai.sequence_number = cp_sequence_number;

Line 1440: FROM IGS_AD_PS_APPL_INST acai

1436: cp_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE) IS
1437: SELECT acai.course_cd,
1438: acai.crv_version_number,
1439: acai.attendance_type
1440: FROM IGS_AD_PS_APPL_INST acai
1441: WHERE acai.person_id = p_person_id AND
1442: acai.admission_appl_number = cp_acai_admission_appl_number AND
1443: acai.nominated_course_cd = cp_acai_nominated_course_cd AND
1444: acai.sequence_number = cp_acai_sequence_number;