APPS.BEN_CWB_UTILS dependencies on FND_PROFILE

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

614: return varchar2
615: is
616: name_profile varchar2(2000);
617: begin
618: fnd_profile.get (p_profile_name, name_profile);
619: return name_profile;
620: end get_profile;
621: --
622: PROCEDURE get_site_profile (

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 635: ,fnd_profile_option_values valu

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
639: AND nvl (options.end_date_active

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 668: ,fnd_profile_option_values valu

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

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 724: ,fnd_profile_option_values valu

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

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

Line 838: ,fnd_profile_option_values valu

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