DBA Data[Home] [Help]

APPS.HR_NZ_PERSON_API dependencies on PER_PEOPLE_F

Line 156: (c_person_id per_people_f.person_id%TYPE,

152: l_legislation_code per_business_groups.legislation_code%TYPE;
153: l_discard_varchar2 VARCHAR2(30);
154: --
155: CURSOR check_legislation
156: (c_person_id per_people_f.person_id%TYPE,
157: c_effective_date DATE
158: )
159: IS
160: SELECT bgp.legislation_code

Line 161: FROM per_people_f per,

157: c_effective_date DATE
158: )
159: IS
160: SELECT bgp.legislation_code
161: FROM per_people_f per,
162: per_business_groups bgp
163: WHERE per.business_group_id = bgp.business_group_id
164: AND per.person_id = c_person_id
165: AND c_effective_date