APPS.IGS_EN_PRC_LOAD dependencies on IGS_EN_SPA_TERMS_API

Line 1822: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, cp_load_cal_type,cp_load_seq_number)='PRIMARY')

1818: WHERE sca.person_id = cp_person_id
1819: AND sca.course_cd = pv.course_cd
1820: AND sca.version_number = pv.version_number
1821: AND (
1822: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, cp_load_cal_type,cp_load_seq_number)='PRIMARY')
1823: OR
1824: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N')
1825: );
1826:

Line 1975: igs_en_spa_terms_api.get_spat_program_version(p_person_id, course_cd,

1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1972:
1973: CURSOR c_active_cd(l_career VARCHAR2) IS
1974: SELECT course_cd,
1975: igs_en_spa_terms_api.get_spat_program_version(p_person_id, course_cd,
1976: p_load_cal_type, p_load_seq_number)
1977:
1978: FROM igs_en_stdnt_ps_att sca
1979: WHERE person_id = p_person_id AND