APPS.IGS_AD_SS_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 3848: FROM igs_en_stdnt_ps_att_all psattmpt

3844:
3845: -- Local College/University
3846: CURSOR c_local_post_sec(cp_person_id igs_ad_appl.person_id%TYPE) IS
3847: SELECT 'x'
3848: FROM igs_en_stdnt_ps_att_all psattmpt
3849: WHERE psattmpt.person_id = cp_person_id
3850: AND psattmpt.course_attempt_status <> 'UNCONFIRM'
3851: AND((NVL(fnd_profile.VALUE('CAREER_MODEL_ENABLED'), 'N') = 'N')
3852: OR(fnd_profile.VALUE('CAREER_MODEL_ENABLED') = 'Y' AND psattmpt.primary_program_type = 'PRIMARY'));