APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on PER_PERSON_TYPE_USAGES

Line 801: from per_person_type_usages ptu

797: and ler.effective_end_date
798: )
799: and (p_person_type_id is null
800: or exists (select null
801: from per_person_type_usages ptu
802: where ptu.person_id = pil.person_id
803: and ptu.person_type_id = p_person_type_id))
804: -- Bug : 2170794 Commented the code below and added the new clauses .
805: /* and ((p_location_id is null