151:
152:
153: CURSOR c_empl_cur(l_temp_res_id2 NUMBER) IS --rhshriva
154: select distinct full_name,person_id,employee_number
155: from per_people_f
156: where
157: p_start_time BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE --for bug 8532793
158: and person_id in (select person_id
159: from bom_resource_employees