APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_PERSON_TYPE_USAGES

Line 661: from per_person_type_usages ptu

657: ecd.cvg_strt_dt and ecd.cvg_thru_dt
658: and (p_person_id is NULL or pen.person_id = P_person_id)
659: and (p_person_type_id is null
660: or exists (select null
661: from per_person_type_usages ptu
662: where ptu.person_id = pen.person_id
663: and ptu.person_type_id = P_person_type_id
664: )
665: )