APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_OIPL_F

Line 37: from ben_oipl_f oipl

33:
34: --- To validate the option , opt_id is compared # 2508745
35: cursor c_opt is
36: select opt_id
37: from ben_oipl_f oipl
38: where oipl.oipl_id = p_oipl_id
39: and p_effective_date between
40: oipl.effective_start_date and
41: oipl.effective_end_date ;

Line 65: ben_oipl_f oipl

61:
62: cursor c_previous_ptip_oipl_result is
63: select pen.prtt_enrt_rslt_id,pen.ENRT_CVG_STRT_DT ,pen.per_in_ler_id
64: from ben_prtt_enrt_rslt_f pen,
65: ben_oipl_f oipl
66: where oipl.oipl_id = pen.oipl_id
67: and pen.pl_typ_id = l_pl_typ_id
68: and oipl.opt_id = l_opt_id
69: and pen.person_id = p_person_id

Line 93: ben_oipl_f oipl

89:
90: cursor c_previous_pl_oipl_result is
91: select pen.prtt_enrt_rslt_id,pen.ENRT_CVG_STRT_DT ,pen.per_in_ler_id
92: from ben_prtt_enrt_rslt_f pen,
93: ben_oipl_f oipl
94: where oipl.oipl_id = pen.oipl_id
95: and pen.pl_typ_id = l_pl_typ_id
96: and oipl.opt_id = l_opt_id
97: and pen.person_id = p_person_id

Line 217: from ben_oipl_f

213: or
214: (r.oipl_id = p_oipl_id)
215: or
216: (r.opt_id = (select opt_id
217: from ben_oipl_f
218: where oipl_id = p_oipl_id
219: and p_effective_date between effective_start_date
220: and effective_end_date
221: and business_group_id = p_business_group_id)))