Product: | PER - Human Resources |
---|---|
Description: | View for the election candidates and results |
Implementation/DBA Data: | APPS.PER_ELC_RESULTS_V |
SELECT EC.ELECTION_CANDIDATE_ID
, PAP.FULL_NAME
, ROLES.NAME
, EC.BUSINESS_GROUP_ID
, EC.ELECTION_ID
, EC.PERSON_ID
, EC.RANK
, EC.ROLE_ID
, EC.ATTRIBUTE_CATEGORY
, EC.ATTRIBUTE1
, EC.ATTRIBUTE2
, EC.ATTRIBUTE3
, EC.ATTRIBUTE4
, EC.ATTRIBUTE5
, EC.ATTRIBUTE6
, EC.ATTRIBUTE7
, EC.ATTRIBUTE8
, EC.ATTRIBUTE9
, EC.ATTRIBUTE10
, EC.ATTRIBUTE11
, EC.ATTRIBUTE12
, EC.ATTRIBUTE13
, EC.ATTRIBUTE14
, EC.ATTRIBUTE15
, EC.ATTRIBUTE16
, EC.ATTRIBUTE17
, EC.ATTRIBUTE18
, EC.ATTRIBUTE19
, EC.ATTRIBUTE20
, EC.ATTRIBUTE21
, EC.ATTRIBUTE22
, EC.ATTRIBUTE23
, EC.ATTRIBUTE24
, EC.ATTRIBUTE25
, EC.ATTRIBUTE26
, EC.ATTRIBUTE27
, EC.ATTRIBUTE28
, EC.ATTRIBUTE29
, EC.ATTRIBUTE30
, EC.CANDIDATE_INFO_CATEGORY
, EC.CANDIDATE_INFORMATION1
, EC.CANDIDATE_INFORMATION2
, EC.CANDIDATE_INFORMATION3
, EC.CANDIDATE_INFORMATION4
, EC.CANDIDATE_INFORMATION5
, EC.CANDIDATE_INFORMATION6
, EC.CANDIDATE_INFORMATION7
, EC.CANDIDATE_INFORMATION8
, EC.CANDIDATE_INFORMATION9
, EC.CANDIDATE_INFORMATION10
, EC.CANDIDATE_INFORMATION11
, EC.CANDIDATE_INFORMATION12
, EC.CANDIDATE_INFORMATION13
, EC.CANDIDATE_INFORMATION14
, EC.CANDIDATE_INFORMATION15
, EC.CANDIDATE_INFORMATION16
, EC.CANDIDATE_INFORMATION17
, EC.CANDIDATE_INFORMATION18
, EC.CANDIDATE_INFORMATION19
, EC.CANDIDATE_INFORMATION20
, EC.CANDIDATE_INFORMATION21
, EC.CANDIDATE_INFORMATION22
, EC.CANDIDATE_INFORMATION23
, EC.CANDIDATE_INFORMATION24
, EC.CANDIDATE_INFORMATION25
, EC.CANDIDATE_INFORMATION26
, EC.CANDIDATE_INFORMATION27
, EC.CANDIDATE_INFORMATION28
, EC.CANDIDATE_INFORMATION29
, EC.CANDIDATE_INFORMATION30
, EC.LAST_UPDATE_DATE
, EC.LAST_UPDATED_BY
, EC.LAST_UPDATE_LOGIN
, EC.CREATED_BY
, EC.CREATION_DATE
, EC.OBJECT_VERSION_NUMBER
, ROLES.JOB_ID
, ROLES.START_DATE
, ROLES.END_DATE
, ROLES.PRIMARY_CONTACT_FLAG
, ROLES.JOB_GROUP_ID
, ROLES.OBJECT_VERSION_NUMBER
FROM PER_ELECTION_CANDIDATES EC
, PER_ALL_PEOPLE_F PAP
, FND_SESSIONS S
, (SELECT JBT.NAME
, RL.ROLE_ID
, RL.JOB_ID
, RL.START_DATE
, RL.END_DATE
, RL.PRIMARY_CONTACT_FLAG
, RL.JOB_GROUP_ID
, RL.OBJECT_VERSION_NUMBER
FROM PER_JOBS_TL JBT
, PER_ROLES RL
WHERE RL.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')) ROLES
WHERE EC.ROLE_ID = ROLES.ROLE_ID (+)
AND EC.PERSON_ID = PAP.PERSON_ID
AND S.SESSION_ID = USERENV('SESSIONID')
AND S.EFFECTIVE_DATE BETWEEN PAP.EFFECTIVE_START_DATE
AND PAP.EFFECTIVE_END_DATE