APPS.HR_AE_PREVIOUS_EMPLOYMENT_API dependencies on PER_PEOPLE_F

Line 73: (c_person_id per_people_f.person_id%TYPE,

69: l_discard_varchar2 varchar2(30);
70: --
71:
72: cursor check_legislation
73: (c_person_id per_people_f.person_id%TYPE,
74: c_effective_date date
75: )
76: is
77: select bgp.legislation_code

Line 78: from per_people_f per,

74: c_effective_date date
75: )
76: is
77: select bgp.legislation_code
78: from per_people_f per,
79: per_business_groups bgp
80: where per.business_group_id = bgp.business_group_id
81: and per.person_id = c_person_id
82: and c_effective_date

Line 255: from per_people_f per,

251: c_effective_date date
252: )
253: is
254: select bgp.legislation_code
255: from per_people_f per,
256: per_business_groups bgp,
257: per_previous_employers pem
258: where per.business_group_id = bgp.business_group_id
259: and per.person_id = pem.person_id