APPS.HR_CN_API dependencies on PER_PEOPLE_F

Line 763: (c_person_id per_people_f.person_id%TYPE,

759: IS
760: l_legislation_code per_business_groups.legislation_code%type;
761: --
762: CURSOR csr_emp_leg
763: (c_person_id per_people_f.person_id%TYPE,
764: c_effective_date DATE
765: )
766: IS
767: select bgp.legislation_code

Line 768: from per_people_f per,

764: c_effective_date DATE
765: )
766: IS
767: select bgp.legislation_code
768: from per_people_f per,
769: per_business_groups bgp
770: where per.business_group_id = bgp.business_group_id
771: and per.person_id = c_person_id
772: and c_effective_date between per.effective_start_date and per.effective_END_date;