DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ALL_PEOPLE_F

Line 3007: From per_all_people_f

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;