APPS.HR_IN_PERSON_ADDRESS_API dependencies on PER_PEOPLE_F

Line 18: (c_person_id per_people_f.person_id%TYPE,

14: IS
15: l_legislation_code per_business_groups.legislation_code%type;
16: --
17: CURSOR csr_emp_leg
18: (c_person_id per_people_f.person_id%TYPE,
19: c_effective_date DATE
20: )
21: IS
22: select bgp.legislation_code

Line 23: from per_people_f per,

19: c_effective_date DATE
20: )
21: IS
22: select bgp.legislation_code
23: from per_people_f per,
24: per_business_groups bgp
25: where per.business_group_id = bgp.business_group_id
26: and per.person_id = c_person_id
27: and c_effective_date between per.effective_start_date and per.effective_END_date;