APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 256: ben_dsgn_rqmt_rlshp_typ drt

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

Line 268: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt

264: )
265: --- if there is no relation typ defind take all
266: or
267: not exists
268: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt
269: where drt.dsgn_rqmt_id = v_dsgn_rqmt_id
270: )
271: ) ;
272: