APPS.HR_RO_PERSON_API dependencies on PER_BUSINESS_GROUPS

Line 126: l_legislation_code per_business_groups.legislation_code%type;

122: --
123:
124: l_proc varchar2(72) := g_package||'update_ro_person';
125: l_effective_date date;
126: l_legislation_code per_business_groups.legislation_code%type;
127: l_discard_varchar2 varchar2(30);
128: --
129: cursor check_legislation
130: (c_person_id per_people_f.person_id%TYPE,

Line 136: per_business_groups bgp

132: )
133: is
134: select bgp.legislation_code
135: from per_people_f per,
136: per_business_groups bgp
137: where per.business_group_id = bgp.business_group_id
138: and per.person_id = c_person_id
139: and c_effective_date
140: between per.effective_start_date and per.effective_end_date;