APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on FND_PROFILE

Line 2539: AND (NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'Y' OR spat.program_cd = p_course_cd );

2535: AND curcv.course_Cd=curspa.course_cd AND curcv.version_number=curspa.version_number
2536: AND spa.person_id=spat.person_id AND spat.program_cd=spa.course_cd
2537: AND cv.course_Cd=spa.course_cd AND cv.version_number=spa.version_number
2538: AND cv.course_type = curcv.course_type
2539: AND (NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'Y' OR spat.program_cd = p_course_cd );
2540:
2541:
2542: CURSOR c_sca IS
2543: SELECT attendance_type, attendance_mode, key_program, fee_cat, igs_pr_class_std_id,

Line 2895: IF NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'N' OR

2891: CLOSE c_sca;
2892: IF (rec_sca.student_confirmed_ind = 'Y') THEN
2893: FOR rec_tl in c_teach_to_load(rec_sca.cal_type)
2894: LOOP
2895: IF NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'N' OR
2896: ('PRIMARY'=igs_en_spa_terms_api.get_spat_primary_prg (new_references.person_id, new_references.course_cd,
2897: rec_tl.load_cal_type, rec_tl.load_ci_sequence_number)) THEN
2898:
2899: OPEN c_term (new_references.person_id, new_references.course_cd,