DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ALL_PEOPLE_F

Line 2980: From per_all_people_f

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;