DBA Data[Home] [Help]

APPS.BEN_EEV_LER dependencies on BEN_PRTT_RT_VAL

Line 12: from ben_prtt_rt_val prv,

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