656: --
657: --Cursor to fetch FNDUSER for Manager
658: CURSOR csr_fnduser IS
659: SELECT user_name 660: FROM fnd_user 661: WHERE employee_id = p_mgr_id
662: AND p_effective_date BETWEEN NVL(start_date,HR_GENERAL.start_of_time) AND NVL(end_date,HR_GENERAL.end_of_time);
663: --
664: --Variable Declarations.