APPS.IGS_AD_UNIT_SETS_PKG dependencies on FND_PROFILE

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

441: )
442: AND psusv.unit_set_cat IN
443: (SELECT usc.unit_set_cat
444: FROM igs_en_unit_set_cat usc
445: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
446: OR usc.s_unit_set_cat = 'PRENRL_YR'))
447: )
448: AND psusv.expiry_dt IS NULL
449: UNION

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

469: )
470: AND us.unit_set_cat IN
471: (SELECT usc.unit_set_cat
472: FROM igs_en_unit_set_cat usc
473: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
474: OR usc.s_unit_set_cat = 'PRENRL_YR'))
475: )
476: AND us.expiry_dt IS NULL;
477: