92: elsif X_No_Holders = 1 then
93: begin
94: -- Bug fix 3681825: Distinct added to sql to avoid fetching multiple rows
95: select DISTINCT p.full_name
96: ,hr_person_type_usage_info.get_worker_number
97: (X_Session_date, p.person_id) worker_number
98: ,hr_person_type_usage_info.get_worker_user_person_type
99: (X_Session_date, p.person_id) user_person_type
100: into X_Holder
94: -- Bug fix 3681825: Distinct added to sql to avoid fetching multiple rows
95: select DISTINCT p.full_name
96: ,hr_person_type_usage_info.get_worker_number
97: (X_Session_date, p.person_id) worker_number
98: ,hr_person_type_usage_info.get_worker_user_person_type
99: (X_Session_date, p.person_id) user_person_type
100: into X_Holder
101: ,X_Employee_Number
102: ,X_User_Person_type