DBA Data[Home] [Help]

APPS.BEN_PEN_BUS dependencies on BEN_LER_BNFT_RSTRN_F

Line 1585: from ben_ler_bnft_rstrn_f rstrn

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

Line 1999: -- Bug 2715942 code addition for ben_ler_bnft_rstrn_f

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