APPS.BEN_PDP_BUS dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 598: ben_dsgn_rqmt_rlshp_typ dr

594: ,r.no_mx_num_dfnd_flag
595: ,r.dsgn_rqmt_id
596: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
597: from ben_dsgn_rqmt_f r,
598: ben_dsgn_rqmt_rlshp_typ dr
599: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
600: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
601: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
602: and r.dsgn_typ_cd = 'DPNT'

Line 650: from ben_dsgn_rqmt_rlshp_typ

646: and d.effective_end_date = hr_api.g_eot -- bug 1237204
647: and d.business_group_id + 0 = p_business_group_id
648: and c.contact_type in
649: (select rlshp_typ_cd
650: from ben_dsgn_rqmt_rlshp_typ
651: where dsgn_rqmt_id = l_dsgn_rqmt_id)
652: ;
653: --
654: