DBA Data[Home] [Help]

APPS.BEN_PEN_BUS dependencies on BEN_LER_BNFT_RSTRN_F

Line 1586: from ben_ler_bnft_rstrn_f rstrn

1582: rstrn.mn_cvg_amt mn_cvg_rqd_amt,
1583: rstrn.mx_cvg_alwd_amt,
1584: rstrn.mx_cvg_rl,
1585: rstrn.mn_cvg_rl
1586: from ben_ler_bnft_rstrn_f rstrn
1587: where rstrn.ler_id = cv_ler_id
1588: and rstrn.pl_id = cv_pl_id
1589: and p_effective_date
1590: between rstrn.effective_start_date

Line 2000: -- Bug 2715942 code addition for ben_ler_bnft_rstrn_f

1996: fnd_message.raise_error;
1997: else
1998: g_pl_cnt := g_pl_cnt + 1 ;
1999: --
2000: -- Bug 2715942 code addition for ben_ler_bnft_rstrn_f
2001: open c_ler(g_enrt_tbl(i).pl_id);
2002: fetch c_ler into l_ler_id ;
2003: close c_ler ;
2004: --