DBA Data[Home] [Help]

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'));