DBA Data[Home] [Help]

APPS.BEN_PRO_LER dependencies on PER_ALL_PEOPLE_F

Line 28: from per_all_people_f a,

24: cursor c_get_person(p_assignment_id in number
25: ,p_effective_date in date)
26: is
27: select a.person_id
28: from per_all_people_f a,
29: per_all_assignments_f asg
30: where a.person_id = asg.person_id
31: and asg.assignment_id = p_assignment_id
32: and asg.business_group_id = a.business_group_id