HR: Query for HR Assignment Form

This query is for Person information regarding his assignment.  
Navigation
Human Resource-> HR-> People-> Enter and Maintain-> More-> Assignment



  SELECT ppf.full_name,
         pap.name position_name,
         pj.name job_name,
         psf.full_name supervisor_name,
         assignment_number,
         gcct.concatenated_segments,
         pbg.name business_group,
         gsb.name ledger_name
    FROM per_assignments_f paf,
         per_people_f ppf,
         per_jobs pj,
         per_all_positions pap,
         per_people_f psf,
         apps.gl_code_combinations_kfv gcct,
         per_business_groups pbg,
         gl_sets_of_books gsb
   WHERE     1 = 1
         AND ppf.person_id = paf.person_id
         AND pj.job_id = paf.job_id
         AND pap.position_id = paf.position_id
         AND psf.person_id = paf.supervisor_id
         AND paf.default_code_comb_id = gcct.code_combination_id
         AND pbg.business_group_id = paf.business_group_id
         AND paf.effective_end_date > SYSDATE
         AND ppf.effective_end_date > SYSDATE
         AND psf.effective_end_date > SYSDATE
         AND gsb.set_of_books_id = paf.set_of_books_id
ORDER BY 1;