APPS.HR_CN_API dependencies on PER_PEOPLE_F

Line 771: (c_person_id per_people_f.person_id%TYPE,

767: IS
768: l_legislation_code per_business_groups.legislation_code%type;
769: --
770: CURSOR csr_emp_leg
771: (c_person_id per_people_f.person_id%TYPE,
772: c_effective_date DATE
773: )
774: IS
775: select bgp.legislation_code

Line 776: from per_people_f per,

772: c_effective_date DATE
773: )
774: IS
775: select bgp.legislation_code
776: from per_people_f per,
777: per_business_groups bgp
778: where per.business_group_id = bgp.business_group_id
779: and per.person_id = c_person_id
780: and c_effective_date between per.effective_start_date and per.effective_END_date;