DBA Data[Home] [Help]

APPS.HR_SE_PERSON_API dependencies on PER_BUSINESS_GROUPS

Line 131: l_legislation_code per_business_groups.legislation_code%type;

127: --
128:
129: l_proc varchar2(72) := g_package||'update_se_person';
130: l_effective_date date;
131: l_legislation_code per_business_groups.legislation_code%type;
132: l_discard_varchar2 varchar2(30);
133: --
134: cursor check_legislation
135: (c_person_id per_people_f.person_id%TYPE,

Line 141: per_business_groups bgp

137: )
138: is
139: select bgp.legislation_code
140: from per_people_f per,
141: per_business_groups bgp
142: where per.business_group_id = bgp.business_group_id
143: and per.person_id = c_person_id
144: and c_effective_date
145: between per.effective_start_date and per.effective_end_date;