APPS.PQH_ROLE_USERS_V1
[Home] [Help]
| Product: | PQH - Public Sector HR |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.PQH_ROLE_USERS_V1
|
SELECT PEI.ROWID ROW_ID
, PEI.PERSON_EXTRA_INFO_ID ROLE_USER_ID
, PEI.PERSON_ID PERSON_ID
, PPF.FULL_NAME PERSON_NAME
, USR.USER_NAME USER_NAME
, USR.USER_ID USER_ID
, RLS.ROLE_NAME ROLE_NAME
, DECODE(INFORMATION_TYPE
, 'PQH_ROLE_USERS'
, TO_NUMBER(PEI.PEI_INFORMATION3)
, 0) ROLE_ID
, PEI.PEI_INFORMATION4 DEFAULT_ROLE
, RLS.ENABLE_FLAG ROLE_ENABLE_FLAG
, PEI.PEI_INFORMATION5 USER_ENABLE_FLAG
, PEI.CREATED_BY CREATED_BY
, PEI.CREATION_DATE CREATION_DATE
, PEI.LAST_UPDATED_BY LAST_UPDATED_BY
, PEI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PEI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PEI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PEI.PEI_INFORMATION6 PEI_INFORMATION6
, PEI.PEI_INFORMATION7 PEI_INFORMATION7
, PEI.PEI_INFORMATION8 PEI_INFORMATION8
, PEI.PEI_INFORMATION9 PEI_INFORMATION9
, PEI.PEI_INFORMATION10 PEI_INFORMATION10
, PEI.PEI_INFORMATION11 PEI_INFORMATION11
, PEI.PEI_INFORMATION12 PEI_INFORMATION12
, PEI.PEI_INFORMATION13 PEI_INFORMATION13
, PEI.PEI_INFORMATION14 PEI_INFORMATION14
, PEI.PEI_INFORMATION15 PEI_INFORMATION15
, PEI.PEI_INFORMATION16 PEI_INFORMATION16
, PEI.PEI_INFORMATION17 PEI_INFORMATION17
, PEI.PEI_INFORMATION18 PEI_INFORMATION18
, PEI.PEI_INFORMATION19 PEI_INFORMATION19
, PEI.PEI_INFORMATION20 PEI_INFORMATION20
, PEI.PEI_INFORMATION21 PEI_INFORMATION21
, PEI.PEI_INFORMATION22 PEI_INFORMATION22
, PEI.PEI_INFORMATION23 PEI_INFORMATION23
, PEI.PEI_INFORMATION24 PEI_INFORMATION24
, PEI.PEI_INFORMATION25 PEI_INFORMATION25
, PEI.PEI_INFORMATION26 PEI_INFORMATION26
, PEI.PEI_INFORMATION27 PEI_INFORMATION27
, PEI.PEI_INFORMATION28 PEI_INFORMATION28
, PEI.PEI_INFORMATION29 PEI_INFORMATION29
, PEI.PEI_INFORMATION30 PEI_INFORMATION30
FROM PER_PEOPLE_EXTRA_INFO PEI
, PER_ALL_PEOPLE_F PPF
, FND_USER USR
, PQH_ROLES RLS
WHERE INFORMATION_TYPE = 'PQH_ROLE_USERS'
AND PEI.PERSON_ID = PPF.PERSON_ID
AND (SELECT SES.EFFECTIVE_DATE
FROM FND_SESSIONS SES
WHERE SES.SESSION_ID = USERENV('SESSIONID')) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND USR.EMPLOYEE_ID = PPF.PERSON_ID
AND RLS.ROLE_ID = TO_NUMBER(PEI.PEI_INFORMATION3)