APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 343: from ben_dsgn_rqmt_f ddr, ben_dsgn_rqmt_rlshp_typ rl

339: ,p_contact_type in varchar2
340: )
341: is
342: select null
343: from ben_dsgn_rqmt_f ddr, ben_dsgn_rqmt_rlshp_typ rl
344: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
345: and rl.rlshp_typ_cd = p_contact_type
346: and (ddr.oipl_id = p_oipl_id
347: or ddr.pl_id = p_pl_id

Line 407: ben_dsgn_rqmt_rlshp_typ rl

403: )
404: is
405: select null
406: from ben_dsgn_rqmt_f ddr,
407: ben_dsgn_rqmt_rlshp_typ rl
408: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
409: and ddr.grp_rlshp_cd is not null
410: and rl.rlshp_typ_cd <> l_contact.contact_type
411: and (ddr.oipl_id = p_oipl_id