Query to Get Employee GOSI Details from Assignment in Oracle APPS

SELECT ppx.employee_number,

       ppx.full_name,

       ppf.payroll_name,

       hsck.concatenated_segments gosi_concatenated_segments,

       SUBSTR (hsck.concatenated_segments,

               0,

               INSTR (hsck.concatenated_segments, '.') - 1)

          employer

  FROM per_assignments_x paaf,

       hr_soft_coding_keyflex hsck,

       pay_payrolls_f ppf,

       per_people_x ppx

 WHERE     paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

       AND paaf.payroll_id = ppf.payroll_id

       AND paaf.assignment_status_type_id = 1

       AND paaf.assignment_type = 'E'

       AND paaf.primary_flag = 'Y'

   AND ppx.person_id = paaf.person_id

       ;