APPS.BEN_CWB_UTILS dependencies on FND_PROFILE_OPTION_VALUES

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