DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 5918: from per_all_people_f

5914: where ast.assignment_status_type_id = p_assignment_status_type_id;
5915:
5916: cursor c_person_enthn is
5917: select person_id,business_group_id,per_information1
5918: from per_all_people_f
5919: where person_id in (select person_id from per_all_assignments_f where assignment_id= p_assignment_id
5920: and p_effective_date between effective_start_date and effective_end_date)
5921: and p_effective_date between effective_start_date and effective_end_date;
5922: