APPS.BEN_CWB_UTILS dependencies on FND_PROFILE

Line 203: fnd_profile.get (p_profile_name, name_profile);

199: return varchar2
200: is
201: name_profile varchar2(2000);
202: begin
203: fnd_profile.get (p_profile_name, name_profile);
204: return name_profile;
205: end get_profile;
206: --
207: PROCEDURE get_site_profile (

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 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 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 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 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

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