APPS.HR_JP_PERSON_API dependencies on PER_BUSINESS_GROUPS

Line 87: l_legislation_code per_business_groups.legislation_code%type;

83: -- Declare cursors and local variables
84: --
85: l_proc varchar2(72) := g_package||'update_jp_person';
86: l_effective_date date;
87: l_legislation_code per_business_groups.legislation_code%type;
88: l_discard_varchar2 varchar2(30);
89: --
90: cursor check_legislation
91: (c_person_id per_people_f.person_id%TYPE,

Line 97: per_business_groups bgp

93: )
94: is
95: select bgp.legislation_code
96: from per_people_f per,
97: per_business_groups bgp
98: where per.business_group_id = bgp.business_group_id
99: and per.person_id = c_person_id
100: and c_effective_date
101: between per.effective_start_date and per.effective_end_date;