Query Soft Coding KeyFlex Field

SELECT PERSON_ID, SEGMENT1 EMPLOYER, SEGMENT2 CIVIL_REG, SEGMENT3 SOCIAL_SEC
FROM HR_SOFT_CODING_KEYFLEX SCK,
PER_ALL_ASSIGNMENTS_F PAAF
WHERE PAAF.SOFT_CODING_KEYFLEX_ID = SCK.SOFT_CODING_KEYFLEX_ID
AND SYSDATE BETWEEN PAAF.EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND PERSON_ID = 25584