DBA Data[Home] [Help]

VIEW: APPS.HRBV_ELECTION_CONSTITUENCYS_V

Source

View Text - Preformatted

SELECT '_DF:PER:PER_ELECTION_CONSTITUENCYS:ECO', ECO.ELECTION_CONSTITUENCY_ID, ECO.ELECTION_ID, ECO.BUSINESS_GROUP_ID, ECO.CONSTITUENCY_ID, ECO.LAST_UPDATE_DATE, ECO.LAST_UPDATED_BY, ECO.CREATED_BY, ECO.CREATION_DATE, CASE WHEN ECO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ECO.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ELECTION_CONSTITUENCYS ECO WITH READ ONLY
View Text - HTML Formatted

SELECT '_DF:PER:PER_ELECTION_CONSTITUENCYS:ECO'
, ECO.ELECTION_CONSTITUENCY_ID
, ECO.ELECTION_ID
, ECO.BUSINESS_GROUP_ID
, ECO.CONSTITUENCY_ID
, ECO.LAST_UPDATE_DATE
, ECO.LAST_UPDATED_BY
, ECO.CREATED_BY
, ECO.CREATION_DATE
, CASE WHEN ECO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ECO.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ELECTION_CONSTITUENCYS ECO WITH READ ONLY