APPS.BEN_MNG_DPNT_BNF dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 244: ben_dsgn_rqmt_rlshp_typ c

240: and
241: (pcr.contact_type in
242: (select c.rlshp_typ_cd
243: from ben_dsgn_rqmt_f p,
244: ben_dsgn_rqmt_rlshp_typ c
245: where p.dsgn_rqmt_id = c.dsgn_rqmt_id
246: and ((p.pl_id = p_new_pl_id)
247: or
248: (p.oipl_id = p_new_oipl_id)

Line 282: from ben_dsgn_rqmt_rlshp_typ c2

278: and new2.dpnt_person_id = pcr2.contact_person_id
279: and pcr2.person_id = p_person_id
280: and pcr2.contact_type in
281: (select rlshp_typ_cd
282: from ben_dsgn_rqmt_rlshp_typ c2
283: where c2.dsgn_rqmt_id = p.dsgn_rqmt_id)))
284: or not exists
285: (select 's'
286: from ben_dsgn_rqmt_f p3

Line 374: ben_dsgn_rqmt_rlshp_typ drt

370: --- validate the no of dpnt for the grp
371: and ( pcr.contact_type in
372: ( select drt.rlshp_typ_cd
373: from ben_dsgn_rqmt_f bdr ,
374: ben_dsgn_rqmt_rlshp_typ drt
375: where bdr.dsgn_rqmt_id = v_dsgn_rqmt_id
376: and drt.dsgn_rqmt_id = bdr.dsgn_rqmt_id
377: and ( bdr.grp_rlshp_cd = v_grp_rlshp_cd or
378: (bdr.grp_rlshp_cd is null and v_grp_rlshp_cd is null )

Line 386: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt

382: )
383: --- if there is no relation typ defind take all
384: or
385: not exists
386: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt
387: where drt.dsgn_rqmt_id = v_dsgn_rqmt_id
388: )
389: ) ;
390: