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;