DBA Data[Home] [Help]

APPS.CSM_PROFILE_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 244: fnd_profile_option_values val

240: p_user_level_value NUMBER
241: ) IS
242: SELECT val.profile_option_value
243: FROM fnd_profile_options opt,
244: fnd_profile_option_values val
245: WHERE NVL(opt.start_date_active, SYSDATE) <= SYSDATE
246: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
247: AND opt.profile_option_name = p_profile_option_name
248: AND opt.application_id = val.application_id