query to get standalone plan attached to employee

Summary:

Hi team, some one please help me on query to get standalone plan attached to employee.
tried below query but not getting results and employee attached to plan in application.

SELECT DISTINCT
papf.person_number,
pl.name plan_name,
pil.per_in_ler_stat_cd life_event_status,
pil.lf_evt_ocrd_dt occurred_date,
pil.strtd_dt open_date,
penr.pl_id,
penr.pgm_id
FROM ben_per_in_ler pil
,ben_prtt_enrt_rslt penr
,ben_pl_f pl
,per_all_people_f papf
WHERE pil.per_in_ler_id = penr.per_in_ler_id
AND pil.person_id = papf.person_id