APPS.BEN_MANAGE_OVERRIDE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 1349: from ben_prtt_enrt_rslt_f pen

1345: ) is
1346: --
1347: cursor c_pen(p_prtt_enrt_rslt_id number) is
1348: select *
1349: from ben_prtt_enrt_rslt_f pen
1350: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1351: and pen.prtt_enrt_rslt_stat_cd IS NULL
1352: order by pen.effective_start_date;
1353: --

Line 1726: ben_prtt_enrt_rslt_f pen

1722: prv.acty_ref_perd_cd,
1723: prv.object_version_number
1724: from ben_prtt_rt_val prv,
1725: ben_acty_base_rt_f abr,
1726: ben_prtt_enrt_rslt_f pen
1727: where prv.prtt_rt_val_id <> p_prtt_rt_val_id
1728: and prv.prtt_rt_val_stat_cd IS NULL
1729: and prv.rt_strt_dt > p_rt_strt_dt
1730: and abr.element_type_id = p_element_type_id

Line 2008: from ben_prtt_enrt_rslt_f pen

2004: l_pea_effective_end_date date;
2005: --
2006: cursor c_pen(p_prtt_enrt_rslt_id number) is
2007: select object_version_number
2008: from ben_prtt_enrt_rslt_f pen
2009: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2010: and pen.sspndd_flag = 'Y'
2011: and pen.prtt_enrt_rslt_stat_cd IS NULL
2012: and p_effective_date between pen.effective_start_date

Line 2025: ben_prtt_enrt_rslt_f pen

2021: ,pea.object_version_number pea_object_version_number
2022: ,pen.object_version_number pen_object_version_number
2023: ,pea.effective_start_date pea_effective_date
2024: from ben_prtt_enrt_actn_f pea,
2025: ben_prtt_enrt_rslt_f pen
2026: where
2027: pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2028: and p_effective_date between pen.effective_start_date and
2029: pen.effective_end_date