SQL query to retrieve employee location country name — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!