DBA Data[Home] [Help]

APPS.IGS_UC_EXPUNGE_APP dependencies on IGS_AD_OU_STAT

Line 236: igs_ad_ou_stat aous

232: apai.sequence_number,
233: apai.adm_outcome_status
234: FROM igs_ad_appl_all aap,
235: igs_ad_ps_appl_inst_all apai,
236: igs_ad_ou_stat aous
237: WHERE aap.alt_appl_id = TO_CHAR(cp_app_no)
238: AND aap.choice_number = NVL(cp_choice_no,aap.choice_number)
239: AND aap.person_id = apai.person_id
240: AND aap.admission_appl_number = apai. admission_appl_number