APPS.IGF_AW_PACKAGING dependencies on IGS_AD_PS_APPL_INST_ALL

Line 5857: igs_ad_ps_appl_inst_all adm,

5853: CURSOR c_get_prog_frm_adm(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
5854: IS
5855: SELECT adm.course_cd key_prog, adm.crv_version_number key_prog_ver
5856: FROM
5857: igs_ad_ps_appl_inst_all adm,
5858: igs_ad_ou_stat s_adm_st,
5859: igf_ap_fa_base_rec_all fabase
5860: WHERE
5861: adm.person_id = fabase.person_id AND

Line 5867: FROM igs_ad_ps_appl_inst_all adm1, igs_ad_ou_stat s_adm_st1

5863: adm.adm_outcome_status = s_adm_st.adm_outcome_status AND
5864: s_adm_st.s_adm_outcome_status IN ('OFFER', 'COND-OFFER') AND
5865: adm.course_cd IS NOT NULL AND
5866: 1 = (SELECT COUNT(person_id)
5867: FROM igs_ad_ps_appl_inst_all adm1, igs_ad_ou_stat s_adm_st1
5868: WHERE
5869: adm1.person_id = adm.person_id AND
5870: adm1.adm_outcome_status = s_adm_st1.adm_outcome_status AND
5871: s_adm_st1.s_adm_outcome_status IN ('OFFER', 'COND-OFFER') AND