APPS.BEN_CWB_UTILS dependencies on FND_PROFILE_OPTIONS

Line 628: l_profile fnd_profile_options.profile_option_name%TYPE;

624: p_value_1 out nocopy varchar2)
625: IS
626:
627: l_defined_z boolean;
628: l_profile fnd_profile_options.profile_option_name%TYPE;
629: CURSOR value_site_profile(v_name varchar2)
630: IS
631: SELECT
632: valu.profile_option_value

Line 634: fnd_profile_options options

630: IS
631: SELECT
632: valu.profile_option_value
633: FROM
634: fnd_profile_options options
635: ,fnd_profile_option_values valu
636: WHERE
637: options.profile_option_name = v_name
638: AND options.start_date_active <= SYSDATE

Line 667: FROM fnd_profile_options options

663:
664: CURSOR value_resp_profile(v_name varchar2, v_resp_id number)
665: IS
666: SELECT valu.profile_option_value
667: FROM fnd_profile_options options
668: ,fnd_profile_option_values valu
669: WHERE options.profile_option_name = upper(v_name)
670: AND options.start_date_active <= sysdate
671: AND nvl(options.end_date_active, sysdate) >= sysdate

Line 723: FROM fnd_profile_options options

719:
720: CURSOR value_user_profile(v_name varchar2, v_user_id number)
721: IS
722: SELECT valu.profile_option_value
723: FROM fnd_profile_options options
724: ,fnd_profile_option_values valu
725: WHERE options.profile_option_name = upper(v_name)
726: AND options.start_date_active <= sysdate
727: AND nvl(options.end_date_active, sysdate) >= sysdate

Line 837: FROM fnd_profile_options options

833:
834: CURSOR value_user_profile(v_name varchar2, v_user_id number)
835: IS
836: SELECT valu.profile_option_value
837: FROM fnd_profile_options options
838: ,fnd_profile_option_values valu
839: WHERE options.profile_option_name = upper(v_name)
840: AND options.start_date_active <= sysdate
841: AND nvl(options.end_date_active, sysdate) >= sysdate