Query to get Employee Positions in Oracle Apps R12 - Orapoint

Overview: This query is use to get the employee’s position with columns like employee number, employee name, position name in Oracle R12 Application

select  distinct
         papf.employee_number,
         papf.full_name,
         hapf.NAME postions,
         paaf.ASS_ATTRIBUTE1 DFF
 from    per_all_assignments_f paaf,
         per_all_people_f papf,
         hr_all_positions_f hapf
 where   paaf.person_id = papf.person_id
 and     paaf.POSITION_ID = hapf.POSITION_ID
 and     sysdate between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE
 and     paaf.ASS_ATTRIBUTE1 is not null;