DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_OU_STAT

Line 540: igs_ad_ou_stat aous

536: acai.*
537: FROM
538: igs_ad_appl aa,
539: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
540: igs_ad_ou_stat aous
541: WHERE
542: acai.adm_outcome_status = aous.adm_outcome_status
543: AND aous.s_adm_outcome_status = 'OFFER-FUTURE-TERM'
544: AND acai.future_acad_cal_type = NVL(p_fut_acad_cal_type, acai.future_acad_cal_type)