SQL to Fetch the Action which action has been performed and when for the cancelled work relationship and Reverse Termination - Thinkapace Consulting – Transforming Businesses with ERP

SQL to Fetch the Action which action has been performed and when for the cancelled work relationship and Reverse Termination

SQL to Fetch the Action which action has been performed and when for the cancelled work relationship and Reverse Termination

SELECT SOAP.CREATED_BY,
SOAP.CREATION_DATE, 
SOAP.LAST_UPDATE_DATE, 
SOAP.LAST_UPDATED_BY UPDATED_USER_NAME,
SOAP.ACTION_OCCURRENCE_ID, 
ACTN.ACTION_CODE, 
SOAP.ACTION_DATE, 
SOAP.PARENT_ENTITY_KEY_ID PERSON_ID ,
ACTN.ACTION_TYPE_CODE

FROM PER_ACTIONS_B ACTN,
PER_ACTION_OCCURRENCES SOAP 
WHERE SOAP.ACTION_ID = ACTN.ACTION_ID

Hire an Employee

Participant and Rate Eligibility for Child

Leave a Reply Cancel reply