APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_DSGN_RQMT_F

Line 503: from ben_dsgn_rqmt_f r

499: select r.mx_dpnts_alwd_num,
500: r.no_mx_num_dfnd_flag,
501: r.dsgn_rqmt_id,
502: r.grp_rlshp_cd
503: from ben_dsgn_rqmt_f r
504: where ((r.pl_id = p_pl_id)
505: or
506: (r.oipl_id = p_oipl_id)
507: or

Line 547: from ben_dsgn_rqmt_f bdr ,

543: and p_effective_date between nvl(pcr.date_start,p_effective_date)
544: and nvl(pcr.date_end,p_effective_date)
545: and (pcr.contact_type in
546: ( select drt.rlshp_typ_cd
547: from ben_dsgn_rqmt_f bdr ,
548: ben_dsgn_rqmt_rlshp_typ drt
549: where bdr.dsgn_rqmt_id = v_dsgn_rqmt_id
550: and drt.dsgn_rqmt_id = bdr.dsgn_rqmt_id
551: and ( bdr.grp_rlshp_cd = v_grp_rlshp_cd or

Line 570: l_grp_rlshp_cd ben_dsgn_rqmt_f.grp_rlshp_cd%type ;

566: l_tot_elig_dpnt number(15);
567: l_tot_rqmt_allow varchar2(30) ;
568: l_ttl_max_num number(15);
569: l_ttl_no_max_flag varchar2(30);
570: l_grp_rlshp_cd ben_dsgn_rqmt_f.grp_rlshp_cd%type ;
571: l_epe_dpnt_rec c_epe_dpnt%rowtype;
572: l_proc varchar2(80) := g_package||'reinstate_dpnt';
573: l_rslt_id number;
574: l_pil_id number;