DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 204: FROM FND_PROFILE_OPTION_VALUES

200: BEGIN
201: IF (lvl_id = '10001') THEN
202: SELECT PROFILE_OPTION_VALUE
203: INTO prof_opt_val
204: FROM FND_PROFILE_OPTION_VALUES
205: WHERE PROFILE_OPTION_ID = prof_opt_id
206: AND LEVEL_ID = lvl_id
207: AND ROWNUM < 2;
208: ELSE

Line 211: FROM FND_PROFILE_OPTION_VALUES

207: AND ROWNUM < 2;
208: ELSE
209: SELECT PROFILE_OPTION_VALUE
210: INTO prof_opt_val
211: FROM FND_PROFILE_OPTION_VALUES
212: WHERE PROFILE_OPTION_ID = prof_opt_id
213: AND LEVEL_ID = lvl_id
214: AND LEVEL_VALUE = lvl_value
215: AND ROWNUM < 2;