APPS.IGF_GR_PELL_CALC dependencies on IGS_AD_OU_STAT

Line 232: igs_ad_ou_stat s_adm_st,

228: adm.course_cd key_prog,
229: adm.crv_version_number key_prog_ver
230: FROM
231: igs_ad_ps_appl_inst_all adm,
232: igs_ad_ou_stat s_adm_st,
233: igf_ap_fa_base_rec_all fabase
234: WHERE
235: adm.person_id = fabase.person_id AND
236: fabase.base_id = p_base_id AND

Line 241: FROM igs_ad_ps_appl_inst_all adm1, igs_ad_ou_stat s_adm_st1

237: adm.adm_outcome_status = s_adm_st.adm_outcome_status AND
238: s_adm_st.s_adm_outcome_status IN ('OFFER', 'COND-OFFER') AND
239: adm.course_cd IS NOT NULL AND
240: 1 = (SELECT COUNT(person_id)
241: FROM igs_ad_ps_appl_inst_all adm1, igs_ad_ou_stat s_adm_st1
242: WHERE
243: adm1.person_id = adm.person_id AND
244: adm1.adm_outcome_status = s_adm_st1.adm_outcome_status AND
245: s_adm_st1.s_adm_outcome_status IN ('OFFER', 'COND-OFFER') AND