APPS.BEN_PLAN_BENEFICIARY_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 83: from ben_prtt_enrt_rslt_f pen ,

79: l_per_in_ler_id ben_pl_bnf_f.per_in_ler_id%TYPE;
80: --
81: cursor c_pil is
82: select pil.per_in_ler_id
83: from ben_prtt_enrt_rslt_f pen ,
84: ben_per_in_ler pil
85: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
86: and pen.per_in_ler_id = pil.per_in_ler_id
87: and pen.prtt_enrt_rslt_stat_cd is null

Line 1596: from ben_prtt_enrt_rslt_f

1592: cursor get_rslt_ovn_c is
1593: select object_version_number,
1594: sspndd_flag,
1595: bnft_amt
1596: from ben_prtt_enrt_rslt_f
1597: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
1598: and business_group_id = l_business_group_id
1599: and prtt_enrt_rslt_stat_cd is null
1600: and p_effective_date

Line 1761: from ben_prtt_enrt_rslt_f a

1757: and business_group_id = p_business_group_id;
1758: --
1759: cursor get_enrt_cvg_strt_dt_c is
1760: select enrt_cvg_strt_dt
1761: from ben_prtt_enrt_rslt_f a
1762: where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1763: and a.business_group_id = p_business_group_id
1764: and a.prtt_enrt_rslt_stat_cd is null
1765: and p_effective_date between nvl(a.effective_start_date, p_effective_date)