APPS.HR_KW_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 254: from per_people_f per,

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