DBA Data[Home] [Help]

APPS.HR_KW_PERSON_API dependencies on PER_PEOPLE_F

Line 137: (c_person_id per_people_f.person_id%TYPE,

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

Line 142: from per_people_f per,

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