Dependent designations mis match between PUI and database tables

 I am looking at an employee- and his dependent designations in PUI.. when i try querying the results from database to get all designee for a plan, i get a dependent who doesn't show up in PUI.

I am using the following query to get dependent designations and all covered dependents... can someone let me know if i am missing something in the query

Select PAPF.full_name, papf.employee_number, pcr.contact_type, dpapf.full_name "Dpnt name", 

dpapf.date_of_birth, round((to_date('02-jan-2013') -dpapf.date_of_birth)/365,3) " Dependent Age",bperf.pl_typ_id,

bperf.pl_id, bperf.oipl_id, bptf.name "Plan Type", bpf.name "Plan Name", dpapf.current_employee_flag