APPS.IGS_AD_UNIT_SETS_PKG dependencies on IGS_EN_UNIT_SET_CAT

Line 444: FROM igs_en_unit_set_cat usc

440: AND uss.s_unit_set_status <> 'INACTIVE'
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

Line 472: FROM igs_en_unit_set_cat usc

468: AND uss.s_unit_set_status <> 'INACTIVE'
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;