APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on PER_PERSON_TYPE_USAGES

Line 815: from per_person_type_usages ptu

811: and ler.effective_end_date
812: )
813: and (p_person_type_id is null
814: or exists (select null
815: from per_person_type_usages ptu
816: where ptu.person_id = pil.person_id
817: and ptu.person_type_id = p_person_type_id))
818: -- Bug : 2170794 Commented the code below and added the new clauses .
819: /* and ((p_location_id is null