APPS.IGS_AD_VAL_ACAI dependencies on FND_PROFILE

Line 251: IF FND_PROFILE.VALUE('OSS_COUNTRY_CODE') = 'GB' AND c_igs_pe_ucas%FOUND THEN

247:
248: OPEN c_igs_pe_ucas(p_person_id);
249: FETCH c_igs_pe_ucas INTO rec_c_igs_pe_ucas;
250:
251: IF FND_PROFILE.VALUE('OSS_COUNTRY_CODE') = 'GB' AND c_igs_pe_ucas%FOUND THEN
252: OPEN c_aav_uk(p_person_id, p_admission_appl_number);
253: FETCH c_aav_uk INTO c_aav_uk_rec;
254: CLOSE c_aav_uk;
255: FOR v_acaiv_rec_uk IN c_acaiv_uk(

Line 1682: WHERE (fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND' ) <> 'Y'

1678: IGS_EN_UNIT_SET_STAT uss
1679: WHERE us.unit_set_cat IN
1680: ( SELECT usc.unit_set_cat
1681: FROM igs_en_unit_set_cat usc
1682: WHERE (fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND' ) <> 'Y'
1683: OR usc.s_unit_set_cat = 'PRENRL_YR') )
1684: AND us.UNIT_SET_STATUS = uss.UNIT_SET_STATUS
1685: AND us.unit_set_cd = cp_unit_set_cd
1686: AND us.version_number = cp_us_version_number;

Line 1728: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'

1724: )
1725: AND psusv.unit_set_cat IN
1726: (SELECT usc.unit_set_cat
1727: FROM igs_en_unit_set_cat usc
1728: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1729: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1730: )
1731: AND psusv.expiry_dt IS NULL
1732: UNION

Line 1756: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'

1752: )
1753: AND us.unit_set_cat IN
1754: (SELECT usc.unit_set_cat
1755: FROM igs_en_unit_set_cat usc
1756: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1757: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1758: )
1759: AND us.expiry_dt IS NULL;
1760: