DBA Data[Home] [Help]

APPS.HR_AU_PERSON_API dependencies on PER_PEOPLE_F

Line 149: (c_person_id per_people_f.person_id%TYPE,

145: l_legislation_code per_business_groups.legislation_code%type;
146: l_discard_varchar2 VARCHAR2(30);
147: --
148: CURSOR check_legislation
149: (c_person_id per_people_f.person_id%TYPE,
150: c_effective_date DATE
151: )
152: IS
153: select bgp.legislation_code

Line 154: from per_people_f per,

150: c_effective_date DATE
151: )
152: IS
153: select bgp.legislation_code
154: from per_people_f per,
155: per_business_groups bgp
156: where per.business_group_id = bgp.business_group_id
157: and per.person_id = c_person_id
158: and c_effective_date