VIEW: APPS.PER_ORGANIZATION_LOV

Source

View Text - Preformatted

SELECT DISTINCT A.PERSON_ID , A.EFFECTIVE_START_DATE , A.EFFECTIVE_END_DATE , O.ORGANIZATION_ID , OTL.NAME , L.MEANING FROM PER_ALL_ASSIGNMENTS_F A, HR_ALL_ORGANIZATION_UNITS_TL OTL, HR_ALL_ORGANIZATION_UNITS O, FND_LOOKUPS L, FND_SESSIONS FND WHERE A.ASSIGNMENT_TYPE = 'E' AND O.ORGANIZATION_ID = A.ORGANIZATION_ID AND L.LOOKUP_CODE = NVL(A.MANAGER_FLAG,'N') AND L.LOOKUP_TYPE = 'YES_NO' AND FND.SESSION_ID = USERENV('sessionid') AND FND.EFFECTIVE_DATE BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID AND OTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT DISTINCT A.PERSON_ID
, A.EFFECTIVE_START_DATE
, A.EFFECTIVE_END_DATE
, O.ORGANIZATION_ID
, OTL.NAME
, L.MEANING
FROM PER_ALL_ASSIGNMENTS_F A
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ALL_ORGANIZATION_UNITS O
, FND_LOOKUPS L
, FND_SESSIONS FND
WHERE A.ASSIGNMENT_TYPE = 'E'
AND O.ORGANIZATION_ID = A.ORGANIZATION_ID
AND L.LOOKUP_CODE = NVL(A.MANAGER_FLAG
, 'N')
AND L.LOOKUP_TYPE = 'YES_NO'
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')