APPS.IGS_AD_VAL_ACAI dependencies on IGS_EN_UNIT_SET_CAT

Line 1681: FROM igs_en_unit_set_cat usc

1677: FROM IGS_EN_UNIT_SET us,
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

Line 1727: FROM igs_en_unit_set_cat usc

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

Line 1755: FROM igs_en_unit_set_cat usc

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