DBA Data[Home] [Help]

APPS.HR_AE_PERSON_API dependencies on PER_PEOPLE_F

Line 143: (c_person_id per_people_f.person_id%TYPE,

139: l_legislation_code per_business_groups.legislation_code%type;
140: l_discard_varchar2 varchar2(30);
141: --
142: cursor check_legislation
143: (c_person_id per_people_f.person_id%TYPE,
144: c_effective_date date
145: )
146: is
147: select bgp.legislation_code

Line 148: from per_people_f per,

144: c_effective_date date
145: )
146: is
147: select bgp.legislation_code
148: from per_people_f per,
149: per_business_groups bgp
150: where per.business_group_id = bgp.business_group_id
151: and per.person_id = c_person_id
152: and c_effective_date