3003: l_designated_receiver_id Number;
3004: begin
3005: Select person_id
3006: Into l_designated_receiver_id 3007: From per_all_people_f 3008: Where employee_number Is Not Null
3009: and business_group_id = p_business_group_id
3010: and p_effective_date between effective_start_date and effective_end_date
3011: and full_name = p_designated_receiver_name;