APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_PERSON_TYPE_USAGES

Line 666: from per_person_type_usages ptu

662: ecd.cvg_strt_dt and ecd.cvg_thru_dt
663: and (p_person_id is NULL or pen.person_id = P_person_id)
664: and (p_person_type_id is null
665: or exists (select null
666: from per_person_type_usages ptu
667: where ptu.person_id = pen.person_id
668: and ptu.person_type_id = P_person_type_id
669: )
670: )