How to fetch US Calculation Card Association,Federal, Regional Details?

Preparing report which pull all the details of 'Tax Withholding' with employee details.

Not able to get all details.

SELECT
papf.person_number,
paam.assignment_status_type,
'Corporate Officer' AS component_information_segment,
pdcdf.dir_information_char2 AS component_value_code,
(
SELECT flv.meaning
FROM fnd_lookup_values flv
WHERE flv.lookup_code = pdcdf.dir_information_char2
AND flv.lookup_type = 'HRX_US_CORPORATE_OFFICER_CODES'
AND flv.language = 'US'
AND ROWNUM = 1
) AS component_value,
pdcdf.dir_comp_detail_id AS "DirCompDetailId",
pdcf.dir_card_id AS "DirCardId",
pdcdf.dir_card_comp_id AS "DirCardCompId",
paam.assignment_number AS "AssignmentNumber",