query to pull Payroll statutory unit regional calculation card details
Summary
query to pull Payroll statutory unit regional calculation card details
Content (please ensure you mask any confidential information):
Hi All,
Greetings!
We are looking for query Regional Calculation card details Regional wise. We are not able to find the Regional ID or code is referred in calculation card tables PAY_DIR_COMP_DETAILS_F , PAY_DIR_CARD_COMPONENTS_F.
Version (include the version you are using, if applicable):
24B
Code Snippet (add any code snippets that support your topic, if applicable):
WITH CTE (EFFECTIVE_START_DATE,BASE_DISPLAY_NAME,DISPLAY_NAME,COMPONENT_NAME,BASE_NAME,NAME,VALUE1,SOURCE_TYPE,VALUE_DEFN_ID,DIR_CARD_ID)