8: l_system_date DATE;
9: --
10: cursor get_person_bg_id IS
11: select per.person_id, per.business_group_id 12: from ben_prtt_rt_val prv, 13: ben_prtt_enrt_rslt per
14: where prv.element_entry_value_id = p_new.element_entry_value_id
15: and l_session_date between rt_strt_dt and rt_end_dt
16: and prv.prtt_enrt_rslt_id = per.prtt_enrt_rslt_id