VIEW: APPS.HRBV_ELECTION_CANDIDATES_V

Source

View Text - Preformatted

SELECT ECA.RANK, ECA.CANDIDATE_INFORMATION1, ECA.CANDIDATE_INFORMATION2, ECA.CANDIDATE_INFORMATION3, ECA.CANDIDATE_INFORMATION4, ECA.CANDIDATE_INFORMATION5, ECA.CANDIDATE_INFORMATION6, ECA.CANDIDATE_INFORMATION7, ECA.CANDIDATE_INFORMATION8, ECA.CANDIDATE_INFORMATION9, ECA.CANDIDATE_INFORMATION10, ECA.CANDIDATE_INFORMATION11, ECA.CANDIDATE_INFORMATION12, ECA.CANDIDATE_INFORMATION13, ECA.CANDIDATE_INFORMATION14, ECA.CANDIDATE_INFORMATION15, ECA.CANDIDATE_INFORMATION16, ECA.CANDIDATE_INFORMATION17, ECA.CANDIDATE_INFORMATION18, ECA.CANDIDATE_INFORMATION19, ECA.CANDIDATE_INFORMATION20, ECA.CANDIDATE_INFORMATION21, ECA.CANDIDATE_INFORMATION22, ECA.CANDIDATE_INFORMATION23, ECA.CANDIDATE_INFORMATION24, ECA.CANDIDATE_INFORMATION25, ECA.CANDIDATE_INFORMATION26, ECA.CANDIDATE_INFORMATION27, ECA.CANDIDATE_INFORMATION28, ECA.CANDIDATE_INFORMATION29, ECA.CANDIDATE_INFORMATION30, ECA.CANDIDATE_INFO_CATEGORY, '_DF:PER:PER_ELECTION_CANDIDATES:ECA', ECA.ELECTION_CANDIDATE_ID, ECA.ELECTION_ID, ECA.PERSON_ID, ECA.ROLE_ID, ECA.BUSINESS_GROUP_ID, ECA.LAST_UPDATE_DATE, ECA.CREATED_BY, ECA.LAST_UPDATED_BY, ECA.CREATION_DATE, CASE WHEN ECA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ECA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ELECTION_CANDIDATES ECA WITH READ ONLY

View Text - HTML Formatted

SELECT ECA.RANK
, ECA.CANDIDATE_INFORMATION1
, ECA.CANDIDATE_INFORMATION2
, ECA.CANDIDATE_INFORMATION3
, ECA.CANDIDATE_INFORMATION4
, ECA.CANDIDATE_INFORMATION5
, ECA.CANDIDATE_INFORMATION6
, ECA.CANDIDATE_INFORMATION7
, ECA.CANDIDATE_INFORMATION8
, ECA.CANDIDATE_INFORMATION9
, ECA.CANDIDATE_INFORMATION10
, ECA.CANDIDATE_INFORMATION11
, ECA.CANDIDATE_INFORMATION12
, ECA.CANDIDATE_INFORMATION13
, ECA.CANDIDATE_INFORMATION14
, ECA.CANDIDATE_INFORMATION15
, ECA.CANDIDATE_INFORMATION16
, ECA.CANDIDATE_INFORMATION17
, ECA.CANDIDATE_INFORMATION18
, ECA.CANDIDATE_INFORMATION19
, ECA.CANDIDATE_INFORMATION20
, ECA.CANDIDATE_INFORMATION21
, ECA.CANDIDATE_INFORMATION22
, ECA.CANDIDATE_INFORMATION23
, ECA.CANDIDATE_INFORMATION24
, ECA.CANDIDATE_INFORMATION25
, ECA.CANDIDATE_INFORMATION26
, ECA.CANDIDATE_INFORMATION27
, ECA.CANDIDATE_INFORMATION28
, ECA.CANDIDATE_INFORMATION29
, ECA.CANDIDATE_INFORMATION30
, ECA.CANDIDATE_INFO_CATEGORY
, '_DF:PER:PER_ELECTION_CANDIDATES:ECA'
, ECA.ELECTION_CANDIDATE_ID
, ECA.ELECTION_ID
, ECA.PERSON_ID
, ECA.ROLE_ID
, ECA.BUSINESS_GROUP_ID
, ECA.LAST_UPDATE_DATE
, ECA.CREATED_BY
, ECA.LAST_UPDATED_BY
, ECA.CREATION_DATE
, CASE WHEN ECA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ECA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ELECTION_CANDIDATES ECA WITH READ ONLY