APPS.BEN_MNG_DPNT_BNF dependencies on BEN_DSGN_RQMT_F

Line 72: l_grp_rlshp_cd ben_dsgn_rqmt_f.grp_rlshp_cd%type ;

68: l_dpnt_elig varchar2(1);
69: --
70: l_ttl_max_num number(15);
71: l_ttl_no_max_flag varchar2(30);
72: l_grp_rlshp_cd ben_dsgn_rqmt_f.grp_rlshp_cd%type ;
73: l_dsgn_rqmt_id number;
74: --
75: l_old_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type; -- Bug 9888746
76: --

Line 85: from ben_dsgn_rqmt_f r

81: select r.mx_dpnts_alwd_num,
82: r.no_mx_num_dfnd_flag,
83: r.dsgn_rqmt_id,
84: r.grp_rlshp_cd
85: from ben_dsgn_rqmt_f r
86: where ((r.pl_id = p_new_pl_id)
87: or
88: (r.oipl_id = p_new_oipl_id)
89: or

Line 243: from ben_dsgn_rqmt_f p,

239: )
240: and
241: (pcr.contact_type in
242: (select c.rlshp_typ_cd
243: from ben_dsgn_rqmt_f p,
244: ben_dsgn_rqmt_rlshp_typ c
245: where p.dsgn_rqmt_id = c.dsgn_rqmt_id
246: and ((p.pl_id = p_new_pl_id)
247: or

Line 286: from ben_dsgn_rqmt_f p3

282: from ben_dsgn_rqmt_rlshp_typ c2
283: where c2.dsgn_rqmt_id = p.dsgn_rqmt_id)))
284: or not exists
285: (select 's'
286: from ben_dsgn_rqmt_f p3
287: where p3.grp_rlshp_cd is not null
288: and ((p3.pl_id = p_new_pl_id)
289: or
290: (p3.oipl_id = p_new_oipl_id)

Line 373: from ben_dsgn_rqmt_f bdr ,

369: and nvl(pcr.date_end,p_effective_date)
370: --- validate the no of dpnt for the grp
371: and ( pcr.contact_type in
372: ( select drt.rlshp_typ_cd
373: from ben_dsgn_rqmt_f bdr ,
374: ben_dsgn_rqmt_rlshp_typ drt
375: where bdr.dsgn_rqmt_id = v_dsgn_rqmt_id
376: and drt.dsgn_rqmt_id = bdr.dsgn_rqmt_id
377: and ( bdr.grp_rlshp_cd = v_grp_rlshp_cd or