APPS.HR_SG_PERSON_API dependencies on PER_BUSINESS_GROUPS

Line 144: l_legislation_code per_business_groups.legislation_code%type;

140: -- Declare cursors and local variables
141: --
142: l_proc VARCHAR2(72) := g_package||'update_sg_person';
143: l_effective_date DATE;
144: l_legislation_code per_business_groups.legislation_code%type;
145: l_discard_varchar2 VARCHAR2(30);
146: --
147: CURSOR check_legislation
148: (c_person_id per_people_f.person_id%TYPE,

Line 154: per_business_groups bgp

150: )
151: IS
152: select bgp.legislation_code
153: from per_people_f per,
154: per_business_groups bgp
155: where per.business_group_id = bgp.business_group_id
156: and per.person_id = c_person_id
157: and c_effective_date
158: between per.effective_start_date and per.effective_end_date;