DBA Data[Home] [Help]

APPS.HR_MX_PERSON_API dependencies on PER_PEOPLE_F

Line 140: (c_person_id per_people_f.person_id%TYPE,

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

Line 145: from per_people_f per,

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