APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 548: ben_dsgn_rqmt_rlshp_typ drt

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
552: (bdr.grp_rlshp_cd is null and v_grp_rlshp_cd is null )

Line 560: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt

556: )
557: --- if there is no relation typ defind take all
558: or
559: not exists
560: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt
561: where drt.dsgn_rqmt_id = v_dsgn_rqmt_id
562: )
563: ) ;
564: