VIEW: APPS.HRBV_PARTICIPANTS_V

Source

View Text - Preformatted

SELECT PAR.PARTICIPATION_IN_TABLE, PAR.PARTICIPATION_IN_COLUMN, PAR.DATE_COMPLETED, PAR.COMMENTS, PAR.PARTICIPATION_TYPE, HR_BIS.BIS_DECODE_LOOKUP('PARTICIPATION_TYPE',PAR.PARTICIPATION_TYPE), PAR.PARTICIPATION_STATUS, HR_BIS.BIS_DECODE_LOOKUP('PARTICIPANT_ACCESS',PAR.PARTICIPATION_STATUS), PAR.LAST_NOTIFIED_DATE, '_DF:PER:PER_PARTICIPANTS:PAR', PAR.PARTICIPANT_ID, PAR.BUSINESS_GROUP_ID, PAR.PARTICIPATION_IN_ID, PAR.PERSON_ID, PAR.QUESTIONNAIRE_TEMPLATE_ID, PAR.LAST_UPDATE_DATE, PAR.LAST_UPDATED_BY, PAR.CREATED_BY, PAR.CREATION_DATE, CASE WHEN PAR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PAR.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_PARTICIPANTS PAR WITH READ ONLY

View Text - HTML Formatted

SELECT PAR.PARTICIPATION_IN_TABLE
, PAR.PARTICIPATION_IN_COLUMN
, PAR.DATE_COMPLETED
, PAR.COMMENTS
, PAR.PARTICIPATION_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('PARTICIPATION_TYPE'
, PAR.PARTICIPATION_TYPE)
, PAR.PARTICIPATION_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('PARTICIPANT_ACCESS'
, PAR.PARTICIPATION_STATUS)
, PAR.LAST_NOTIFIED_DATE
, '_DF:PER:PER_PARTICIPANTS:PAR'
, PAR.PARTICIPANT_ID
, PAR.BUSINESS_GROUP_ID
, PAR.PARTICIPATION_IN_ID
, PAR.PERSON_ID
, PAR.QUESTIONNAIRE_TEMPLATE_ID
, PAR.LAST_UPDATE_DATE
, PAR.LAST_UPDATED_BY
, PAR.CREATED_BY
, PAR.CREATION_DATE
, CASE WHEN PAR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PAR.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_PARTICIPANTS PAR WITH READ ONLY