APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_OIPL_F

Line 295: select opt_id from ben_oipl_f oipl

291: --
292: -- Define cursors
293: --
294: cursor c_opt is
295: select opt_id from ben_oipl_f oipl
296: where oipl.oipl_id = p_oipl_id
297: and oipl.business_group_id = p_business_group_id
298: and l_lf_evt_ocrd_dt
299: between oipl.effective_start_date

Line 577: from ben_oipl_f oipl

573: from ben_dsgn_rqmt_f ddr
574: where (ddr.oipl_id = p_oipl_id
575: or ddr.pl_id = p_pl_id
576: or ddr.opt_id = (select oipl.opt_id
577: from ben_oipl_f oipl
578: where oipl.oipl_id = p_oipl_id
579: and oipl.business_group_id =
580: p_business_group_id
581: and l_lf_evt_ocrd_dt

Line 638: ben_oipl_f oipl,

634: select decode(pln.invk_dcln_prtn_pl_flag,
635: 'N', nvl(opt.invk_wv_opt_flag,'N'),
636: 'Y') dcln_pl_opt_flag
637: from ben_pl_f pln,
638: ben_oipl_f oipl,
639: ben_opt_f opt
640: where pln.pl_id = p_pl_id
641: and oipl.oipl_id (+) = p_oipl_id
642: and oipl.pl_id (+) = pln.pl_id