DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 5140: from ben_dsgn_rqmt_rlshp_typ drrt

5136: and ecd.dpnt_person_id = pcr.contact_person_id
5137: and pcr.business_group_id = p_business_group_id
5138: and pcr.contact_type in
5139: (select drrt.rlshp_typ_cd
5140: from ben_dsgn_rqmt_rlshp_typ drrt
5141: where drrt.dsgn_rqmt_id = drq.dsgn_rqmt_id)
5142: and pil.per_in_ler_id=ecd.per_in_ler_id
5143: and pil.business_group_id=p_business_group_id
5144: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT'));