APPS.BEN_MNG_DPNT_BNF dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 159: ben_dsgn_rqmt_rlshp_typ c

155: and
156: (pcr.contact_type in
157: (select c.rlshp_typ_cd
158: from ben_dsgn_rqmt_f p,
159: ben_dsgn_rqmt_rlshp_typ c
160: where p.dsgn_rqmt_id = c.dsgn_rqmt_id
161: and ((p.pl_id = p_new_pl_id)
162: or
163: (p.oipl_id = p_new_oipl_id)

Line 197: from ben_dsgn_rqmt_rlshp_typ c2

193: and new2.dpnt_person_id = pcr2.contact_person_id
194: and pcr2.person_id = p_person_id
195: and pcr2.contact_type in
196: (select rlshp_typ_cd
197: from ben_dsgn_rqmt_rlshp_typ c2
198: where c2.dsgn_rqmt_id = p.dsgn_rqmt_id)))
199: or not exists
200: (select 's'
201: from ben_dsgn_rqmt_f p3

Line 289: ben_dsgn_rqmt_rlshp_typ drt

285: --- validate the no of dpnt for the grp
286: and ( pcr.contact_type in
287: ( select drt.rlshp_typ_cd
288: from ben_dsgn_rqmt_f bdr ,
289: ben_dsgn_rqmt_rlshp_typ drt
290: where bdr.dsgn_rqmt_id = v_dsgn_rqmt_id
291: and drt.dsgn_rqmt_id = bdr.dsgn_rqmt_id
292: and ( bdr.grp_rlshp_cd = v_grp_rlshp_cd or
293: (bdr.grp_rlshp_cd is null and v_grp_rlshp_cd is null )

Line 301: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt

297: )
298: --- if there is no relation typ defind take all
299: or
300: not exists
301: (select 'x' from ben_dsgn_rqmt_rlshp_typ drt
302: where drt.dsgn_rqmt_id = v_dsgn_rqmt_id
303: )
304: ) ;
305: