DBA Data[Home] [Help]

APPS.HR_SA_PERSON_API dependencies on PER_PEOPLE_F

Line 138: (c_person_id per_people_f.person_id%TYPE,

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

Line 143: from per_people_f per,

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