Query for getting Pay Scale Details for the Employees.

SELECT
papf.employee_number,
pg.name,
hrfg.grade_step,
pgrf.value
FROM
per_all_people_f papf,
per_all_assignments_f paaf,
pay_grade_rules_f pgrf,
        per_spinal_point_steps_f pgspsf,
        per_spinal_points psp,
        hrfg_grade_steps hrfg,
        per_grade_spines_f pgsf,
        per_grades pg
WHERE
papf.business_group_id = P_BUSINESS_GROUP_ID
AND papf.current_employee_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date
AND papf.person_id = paaf.person_id
AND TRUNC(SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND paaf.primary_flag = 'Y'
AND pg.name = paaf.grade_id
        AND hrfg.grade_id = pg.grade_id
        AND hrfg.grade_step_id = pgspsf.step_id
        AND TRUNC(SYSDATE) BETWEEN pgspsf.effective_start_date AND pgspsf.effective_end_date
        AND psp.spinal_point_id = pgspsf.grade_spine_id
        AND pgsf.grade_spine_id = pgspsf.grade_spine_id
        AND hrfg.grade_id = pgsf.grade_id
        AND TRUNC(SYSDATE) BETWEEN pgsf.effective_start_date AND pgsf.effective_end_date
        AND pgspsf.spinal_point_id = pgrf.grade_or_spinal_point_id
        AND TRUNC(SYSDATE) BETWEEN pgrf.effective_start_date AND pgrf.effective_end_date;