Product: | PER - Human Resources |
---|---|
Description: | View for the election information to support for elections form. |
Implementation/DBA Data: | APPS.PER_ELECTIONS_V |
SELECT PE.ELECTION_ID
, HAOU.NAME
, PE.BUSINESS_GROUP_ID
, PE.ELECTION_DATE
, PE.DESCRIPTION
, PE.REP_BODY_ID
, PE.PREVIOUS_ELECTION_DATE
, PE.NEXT_ELECTION_DATE
, PE.RESULT_PUBLISH_DATE
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.ATTRIBUTE11
, PE.ATTRIBUTE12
, PE.ATTRIBUTE13
, PE.ATTRIBUTE14
, PE.ATTRIBUTE15
, PE.ATTRIBUTE16
, PE.ATTRIBUTE17
, PE.ATTRIBUTE18
, PE.ATTRIBUTE19
, PE.ATTRIBUTE20
, PE.ATTRIBUTE21
, PE.ATTRIBUTE22
, PE.ATTRIBUTE23
, PE.ATTRIBUTE24
, PE.ATTRIBUTE25
, PE.ATTRIBUTE26
, PE.ATTRIBUTE27
, PE.ATTRIBUTE28
, PE.ATTRIBUTE29
, PE.ATTRIBUTE30
, PE.ELECTION_INFO_CATEGORY
, PE.ELECTION_INFORMATION1
, PE.ELECTION_INFORMATION2
, PE.ELECTION_INFORMATION3
, PE.ELECTION_INFORMATION4
, PE.ELECTION_INFORMATION5
, PE.ELECTION_INFORMATION6
, PE.ELECTION_INFORMATION7
, PE.ELECTION_INFORMATION8
, PE.ELECTION_INFORMATION9
, PE.ELECTION_INFORMATION10
, PE.ELECTION_INFORMATION11
, PE.ELECTION_INFORMATION12
, PE.ELECTION_INFORMATION13
, PE.ELECTION_INFORMATION14
, PE.ELECTION_INFORMATION15
, PE.ELECTION_INFORMATION16
, PE.ELECTION_INFORMATION17
, PE.ELECTION_INFORMATION18
, PE.ELECTION_INFORMATION19
, PE.ELECTION_INFORMATION20
, PE.ELECTION_INFORMATION21
, PE.ELECTION_INFORMATION22
, PE.ELECTION_INFORMATION23
, PE.ELECTION_INFORMATION24
, PE.ELECTION_INFORMATION25
, PE.ELECTION_INFORMATION26
, PE.ELECTION_INFORMATION27
, PE.ELECTION_INFORMATION28
, PE.ELECTION_INFORMATION29
, PE.ELECTION_INFORMATION30
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_LOGIN
, PE.CREATED_BY
, PE.CREATION_DATE
, PE.OBJECT_VERSION_NUMBER
FROM PER_ELECTIONS PE
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE PE.REP_BODY_ID = HAOU.ORGANIZATION_ID