948: BEGIN
949: declare
950: cursor user_lookup (userid in number, username in varchar2) is
951: SELECT user_id 952: FROM fnd_user 953: WHERE user_id = NVL(userid,user_id)
954: AND user_name = DECODE(userid,null,username,user_name)
955: AND nvl(start_date , sysdate) <= sysdate
956: AND nvl(end_date,sysdate) >= sysdate;