DBA Data[Home] [Help]

APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_PL_F

Line 22: from ben_oipl_f oipl, ben_pl_f pl

18: ,p_out_opt_id out nocopy number) is
19:
20: cursor c_opt(p_oipl_id number) is
21: select oipl.opt_id, oipl.pl_id, pl.pl_typ_id
22: from ben_oipl_f oipl, ben_pl_f pl
23: where oipl.oipl_id = p_oipl_id
24: and pl.pl_id = oipl.pl_id
25: and p_effective_date
26: between pl.effective_start_date

Line 34: from ben_pl_f pl

30: and oipl.effective_end_date;
31:
32: cursor c_pl(p_pl_id number) is
33: select pl.pl_id, pl.pl_typ_id
34: from ben_pl_f pl
35: where pl.pl_id = p_pl_id
36: and p_effective_date
37: between pl.effective_start_date
38: and pl.effective_end_date;