calculation card link with legal employer

Summary:

we are trying to fetch the below calculation card with specific legal employer

Could you please let me know if any query is available or guide me on the linking between the calculations card table and PAY_DIR_REP_CARDS_F table

Content (required):

SELECT distinct comp_det.dir_card_comp_id ,card_comp.DIR_CARD_ID

FROM 

fusion.pay_dir_card_definitions_tl card_def,

fusion.pay_dir_card_comp_defs_tl card_comp_def,

fusion.pay_dir_card_components_f card_comp,

PAY_DIR_COMP_DETAILS_F comp_det 

WHERE 1=1

AND card_comp_def.dir_card_comp_def_id = card_comp.dir_card_comp_def_id