APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_DSGN_RQMT_RLSHP_TYP
Line 5155: from ben_dsgn_rqmt_rlshp_typ drrt
5151: and ecd.dpnt_person_id = pcr.contact_person_id
5152: and pcr.business_group_id = p_business_group_id
5153: and pcr.contact_type in
5154: (select drrt.rlshp_typ_cd 5155: from ben_dsgn_rqmt_rlshp_typ drrt 5156: where drrt.dsgn_rqmt_id = drq.dsgn_rqmt_id)
5157: and pil.per_in_ler_id=ecd.per_in_ler_id
5158: and pil.business_group_id=p_business_group_id
5159: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT'));