DBA Data[Home] [Help]

APPS.BEN_CWB_UTILS dependencies on FND_PROFILE_OPTION_VALUES

Line 218: ,fnd_profile_option_values valu

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
222: AND options.profile_option_id = valu.profile_option_id

Line 247: ,fnd_profile_option_values valu

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
251: AND options.profile_option_id = valu.profile_option_id

Line 295: ,fnd_profile_option_values valu

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
299: AND options.profile_option_id = valu.profile_option_id