APPS.IGS_AD_SS_GEN_001 dependencies on FND_PROFILE

Line 3851: AND((NVL(fnd_profile.VALUE('CAREER_MODEL_ENABLED'), 'N') = 'N')

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'));
3853:
3854:
3855: -- Admission Test Results- ADM_TEST_RESULTS

Line 3852: OR(fnd_profile.VALUE('CAREER_MODEL_ENABLED') = 'Y' AND psattmpt.primary_program_type = 'PRIMARY'));

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'));
3853:
3854:
3855: -- Admission Test Results- ADM_TEST_RESULTS
3856: CURSOR c_test_rslts(cp_person_id igs_ad_appl.person_id%TYPE, cp_ApplType igs_ad_appl.APPLICATION_TYPE%TYPE) IS

Line 5894: SELECT FND_PROFILE.VALUE('IGS_AD_PRESUB_APPL_UHK') value

5890: FUNCTION wf_submit_application_sub(p_subscription_guid IN RAW,
5891: p_event IN OUT NOCOPY WF_EVENT_T) return varchar2
5892: IS
5893: CURSOR c_pre_sub_uhk_prl IS
5894: SELECT FND_PROFILE.VALUE('IGS_AD_PRESUB_APPL_UHK') value
5895: FROM dual;
5896:
5897:
5898: l_person_id NUMBER;