825: b_resp_level_value NUMBER,
826: b_user_level_value NUMBER
827: ) IS
828: SELECT val.profile_option_value
829: FROM fnd_profile_options opt,
830: fnd_profile_option_values val
831: WHERE NVL(opt.start_date_active, SYSDATE) <= SYSDATE
832: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
833: AND opt.profile_option_name = b_profile_option_name