APPS.IGS_AD_GEN_014 dependencies on FND_PROFILE

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

1531: IGS_EN_UNIT_SET_STAT uss
1532: WHERE us.unit_set_cat IN
1533: ( SELECT usc.unit_set_cat
1534: FROM igs_en_unit_set_cat usc
1535: WHERE (fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND' ) <> 'Y'
1536: OR usc.s_unit_set_cat = 'PRENRL_YR') )
1537: AND us.UNIT_SET_STATUS = uss.UNIT_SET_STATUS
1538: AND us.unit_set_cd = cp_unit_set_cd
1539: AND us.version_number = cp_us_version_number;

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

1578: )
1579: AND psusv.unit_set_cat IN
1580: (SELECT usc.unit_set_cat
1581: FROM igs_en_unit_set_cat usc
1582: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1583: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1584: )
1585: AND psusv.expiry_dt IS NULL
1586: UNION

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

1606: )
1607: AND us.unit_set_cat IN
1608: (SELECT usc.unit_set_cat
1609: FROM igs_en_unit_set_cat usc
1610: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1611: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1612: )
1613: AND us.expiry_dt IS NULL;
1614: