EMPLOYEE TAX CARD QUERY for MEXICO - CalculationValueDefinition

Hi team,

when we are trying to fetch the CalculationValueDefinition component data for Calculation Card MX, the ValueDefinitionName was empty. We are using below query but here source id is empty so unable to join that table PAY_VALUE_DEFINITIONS_VL . Can anyone suggest on this? we dont see any other column to join with this.

---CalculationValueDefinition---


SELECT DISTINCT


pldg.name ldg
,pdcdt.display_name "DirCardDefinitionName"
,to_char (pdccf.effective_start_date, 'yyyy/mm/dd')
,paaf.ASSIGNMENT_NUMBER
,pdccdv.component_name "DirCardCompDefName"
,pdcf.card_sequence
,pdccf.COMPONENT_SEQUENCE
,pvdv.name "ValueDefinitionName"



FROM pay_dir_cards_f pdcf
, pay_dir_card_definitions_tl pdcdt