Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
SQL query to retrieve employee location country name
Summary:
Content (please ensure you mask any confidential information):
Hello experts,
we need a query to retrieve the employee location country name but below it extracts country code.
Is it possible to retrieve the entire country name?
SELECT L.COUNTRY FROM HR_LOCATIONS_ALL L,PER_ALL_ASSIGNMENTS_M ASG
WHERE
ASG.ASSIGNMENT_ID =:{PARAMETER.ASSIGNMENT_ID}
AND TRUNC(SYSDATE) BETWEEN TRUNC(ASG.EFFECTIVE_START_DATE) AND TRUNC(ASG.EFFECTIVE_END_DATE)
AND ASG.LOCATION_ID=L.LOCATION_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(L.EFFECTIVE_START_DATE) AND TRUNC(L.EFFECTIVE_END_DATE)
Thanks in advance for your time!
Tagged:
0