DBA Data[Home] [Help]

VIEW: APPS.HRBV_SALARY_SURVEYS_V

Source

View Text - Preformatted

SELECT PSS.SURVEY_NAME, PSS.SURVEY_COMPANY_CODE, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_COMPANY',PSS.SURVEY_COMPANY_CODE), PSS.IDENTIFIER, PSS.SURVEY_TYPE_CODE, HR_BIS.BIS_DECODE_LOOKUP('PAY_BASIS',PSS.SURVEY_TYPE_CODE), PSS.BASE_REGION, '_DF:PER:PER_SALARY_SURVEYS:PSS', PSS.SALARY_SURVEY_ID, PSS.LAST_UPDATE_DATE, PSS.LAST_UPDATED_BY, PSS.CREATED_BY, PSS.CREATION_DATE FROM PER_SALARY_SURVEYS PSS WITH READ ONLY
View Text - HTML Formatted

SELECT PSS.SURVEY_NAME
, PSS.SURVEY_COMPANY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_COMPANY'
, PSS.SURVEY_COMPANY_CODE)
, PSS.IDENTIFIER
, PSS.SURVEY_TYPE_CODE
, HR_BIS.BIS_DECODE_LOOKUP('PAY_BASIS'
, PSS.SURVEY_TYPE_CODE)
, PSS.BASE_REGION
, '_DF:PER:PER_SALARY_SURVEYS:PSS'
, PSS.SALARY_SURVEY_ID
, PSS.LAST_UPDATE_DATE
, PSS.LAST_UPDATED_BY
, PSS.CREATED_BY
, PSS.CREATION_DATE
FROM PER_SALARY_SURVEYS PSS WITH READ ONLY