Query to extract Position Information

 select    hrc.source_system_owner,
          hrc.source_system_id,
          hrc.object_name,
          hap.position_code,
          hap.name position_name,
(SELECT name
  FROM HR_ALL_POSITIONS
  WHERE POSITION_ID = pphf.PARENT_POSITION_ID
  ) Parent_Position_NAME,
(SELECT position_code
FROM HR_ALL_POSITIONS
WHERE POSITION_ID = pphf.PARENT_POSITION_ID
) Parent_Position_code
,(SELECT haou1.name
  FROM HR_ALL_POSITIONS HAPP
   ,HR_ALL_ORGANIZATION_UNITS haou1
  WHERE HAPP.POSITION_ID = pphf.PARENT_POSITION_ID
AND hapP.business_unit_id = haou1.organization_id
  ) Parent_BusinessUnit_Name
,decode(hap.ACTIVE_STATUS, 'A', 'Active', 'I', 'Inactive') ACTIVE_Status,
haou.name BusinessUnit_Name,
pj.name Job_Name,
pj.job_code job_code,
dept.NAME department,
HAP.POSITION_TYPE,
HAP.FTE,
hap.MAX_PERSONS head_count,
hap.OVERLAP_ALLOWED,
hap.STANDARD_WORKING_HOURS,
hap.STANDARD_WORKING_FREQUENCY,
hap.WORKING_HOURS actual_working_hours,
hap.frequency actual_working_hours_frequency,
pglft.name Gradeladdername,
(
select pgf.name 
  from PER_GRADES_F_TL PGF
  where pgf.grade_id = hap.entry_grade_id
) entry_grade,
(
select pgsf.name  
  from PER_GRADE_STEPS_F_TL PGSF
  where pGSF.grade_step_id = HAP.ENTRY_STEP_ID
) entry_grade_step
from hrc_integration_key_map hrc,
        HR_ALL_POSITIONS_F_VL hap,
        PER_POSITION_HIERARCHY_F pphf,
        HR_ALL_ORGANIZATION_UNITS haou,
        PER_JOBS_F_VL PJ,
        PER_DEPARTMENTS dept,
PER_GRADE_LADDERS_F_TL pglft
where hrc.object_name like 'Position'
 and hrc.surrogate_id = hap.position_id 
 AND hap.POSITION_ID = pphf.POSITION_ID(+)
 AND hap.business_unit_id = haou.organization_id
 AND sysdate BETWEEN pphf.effective_start_date AND pphf.effective_end_date 
 AND hap.job_id = pj.job_id
 AND dept.organization_id = hap.organization_id
 and pglft.grade_ladder_id = hap.grade_ladder_id