APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_DSGN_RQMT_F

Line 211: from ben_dsgn_rqmt_f r

207: select r.mx_dpnts_alwd_num,
208: r.no_mx_num_dfnd_flag,
209: r.dsgn_rqmt_id,
210: r.grp_rlshp_cd
211: from ben_dsgn_rqmt_f r
212: where ((r.pl_id = p_pl_id)
213: or
214: (r.oipl_id = p_oipl_id)
215: or

Line 255: from ben_dsgn_rqmt_f bdr ,

251: and p_effective_date between nvl(pcr.date_start,p_effective_date)
252: and nvl(pcr.date_end,p_effective_date)
253: and (pcr.contact_type in
254: ( select drt.rlshp_typ_cd
255: from ben_dsgn_rqmt_f bdr ,
256: ben_dsgn_rqmt_rlshp_typ drt
257: where bdr.dsgn_rqmt_id = v_dsgn_rqmt_id
258: and drt.dsgn_rqmt_id = bdr.dsgn_rqmt_id
259: and ( bdr.grp_rlshp_cd = v_grp_rlshp_cd or

Line 278: l_grp_rlshp_cd ben_dsgn_rqmt_f.grp_rlshp_cd%type ;

274: l_tot_elig_dpnt number(15);
275: l_tot_rqmt_allow varchar2(30) ;
276: l_ttl_max_num number(15);
277: l_ttl_no_max_flag varchar2(30);
278: l_grp_rlshp_cd ben_dsgn_rqmt_f.grp_rlshp_cd%type ;
279: l_epe_dpnt_rec c_epe_dpnt%rowtype;
280: l_proc varchar2(80) := g_package||'reinstate_dpnt';
281: l_rslt_id number;
282: l_pil_id number;