APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 336: from ben_dsgn_rqmt_f ddr, ben_dsgn_rqmt_rlshp_typ rl

332: ,p_contact_type in varchar2
333: )
334: is
335: select null
336: from ben_dsgn_rqmt_f ddr, ben_dsgn_rqmt_rlshp_typ rl
337: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
338: and rl.rlshp_typ_cd = p_contact_type
339: and (ddr.oipl_id = p_oipl_id
340: or ddr.pl_id = p_pl_id

Line 400: ben_dsgn_rqmt_rlshp_typ rl

396: )
397: is
398: select null
399: from ben_dsgn_rqmt_f ddr,
400: ben_dsgn_rqmt_rlshp_typ rl
401: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
402: and ddr.grp_rlshp_cd is not null
403: and rl.rlshp_typ_cd <> l_contact.contact_type
404: and (ddr.oipl_id = p_oipl_id