Canada - Calculation Card Tax Reporting Unit Association Assignment Query

Summary:

Oracle HCM Payroll-->
Payroll Calculation Card --- Tax Credit Information

--> Associations
Tax Reporting Unit ---> XXLegal Entity Association LimitedRP0001

Assignment
E9000001-2

I have a Requirement to get the Assignment Number in the query, I have created below query but I am not able to figure out where to get Assignment Number
I was thinking "pay_dir_rep_card_usages_f " might have Assignment Number

Content (please ensure you mask any confidential information):

SELECT
pdrc.tax_unit_id,
pprd.person_id,
pprd.payroll_relationship_number,
tru.estab_name
FROM
pay_dir_cards_f pdc,
pay_dir_card_definitions pdcd,