2976: l_designated_receiver_id Number;
2977: begin
2978: Select person_id
2979: Into l_designated_receiver_id 2980: From per_all_people_f 2981: Where employee_number Is Not Null
2982: and business_group_id = p_business_group_id
2983: and p_effective_date between effective_start_date and effective_end_date
2984: and full_name = p_designated_receiver_name;