DBA Data[Home] [Help]

APPS.BEN_CWB_UTILS dependencies on FND_PROFILE_OPTIONS

Line 217: FROM fnd_profile_options options

213:
214: CURSOR value_site_profile(v_name varchar2)
215: IS
216: SELECT valu.profile_option_value
217: FROM fnd_profile_options options
218: ,fnd_profile_option_values valu
219: WHERE options.profile_option_name = upper(v_name)
220: AND options.start_date_active <= sysdate
221: AND nvl(options.end_date_active, sysdate) >= sysdate

Line 246: FROM fnd_profile_options options

242:
243: CURSOR value_resp_profile(v_name varchar2, v_resp_id number)
244: IS
245: SELECT valu.profile_option_value
246: FROM fnd_profile_options options
247: ,fnd_profile_option_values valu
248: WHERE options.profile_option_name = upper(v_name)
249: AND options.start_date_active <= sysdate
250: AND nvl(options.end_date_active, sysdate) >= sysdate

Line 294: FROM fnd_profile_options options

290:
291: CURSOR value_user_profile(v_name varchar2, v_user_id number)
292: IS
293: SELECT valu.profile_option_value
294: FROM fnd_profile_options options
295: ,fnd_profile_option_values valu
296: WHERE options.profile_option_name = upper(v_name)
297: AND options.start_date_active <= sysdate
298: AND nvl(options.end_date_active, sysdate) >= sysdate