VIEW: APPS.HRBV_SALARY_SURVEY_LINES_V

Source

View Text - Preformatted

SELECT SSL.SURVEY_JOB_NAME_CODE, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_JOB_NAME',SSL.SURVEY_JOB_NAME_CODE), SSL.SURVEY_REGION_CODE, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_REGION',SSL.SURVEY_REGION_CODE), SSL.SURVEY_SENIORITY_CODE, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_SENIORITY',SSL.SURVEY_SENIORITY_CODE), SSL.COMPANY_SIZE_CODE, HR_BIS.BIS_DECODE_LOOKUP('COMPANY_SIZE',SSL.COMPANY_SIZE_CODE), SSL.INDUSTRY_CODE, HR_BIS.BIS_DECODE_LOOKUP('INDUSTRY',SSL.INDUSTRY_CODE), SSL.SURVEY_AGE_CODE, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_AGE',SSL.SURVEY_AGE_CODE), SSL.START_DATE, SSL.END_DATE, SSL.DIFFERENTIAL, SSL.CURRENCY_CODE, SSL.MINIMUM_PAY, SSL.MEAN_PAY, SSL.MAXIMUM_PAY, SSL.GRADUATE_PAY, SSL.STARTING_PAY, SSL.PERCENTAGE_CHANGE, SSL.JOB_FIRST_QUARTILE, SSL.JOB_MEDIAN_QUARTILE, SSL.JOB_THIRD_QUARTILE, SSL.JOB_FOURTH_QUARTILE, SSL.MINIMUM_TOTAL_COMPENSATION, SSL.MEAN_TOTAL_COMPENSATION, SSL.MAXIMUM_TOTAL_COMPENSATION, SSL.COMPNSTN_FIRST_QUARTILE, SSL.COMPNSTN_MEDIAN_QUARTILE, SSL.COMPNSTN_THIRD_QUARTILE, SSL.COMPNSTN_FOURTH_QUARTILE, '_DF:PER:PER_SALARY_SURVEY_LINES:SSL', SSL.SALARY_SURVEY_ID, SSL.SALARY_SURVEY_LINE_ID, SSL.LAST_UPDATE_DATE, SSL.LAST_UPDATED_BY, SSL.CREATED_BY, SSL.CREATION_DATE FROM PER_SALARY_SURVEY_LINES SSL WITH READ ONLY

View Text - HTML Formatted

SELECT SSL.SURVEY_JOB_NAME_CODE
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_JOB_NAME'
, SSL.SURVEY_JOB_NAME_CODE)
, SSL.SURVEY_REGION_CODE
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_REGION'
, SSL.SURVEY_REGION_CODE)
, SSL.SURVEY_SENIORITY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_SENIORITY'
, SSL.SURVEY_SENIORITY_CODE)
, SSL.COMPANY_SIZE_CODE
, HR_BIS.BIS_DECODE_LOOKUP('COMPANY_SIZE'
, SSL.COMPANY_SIZE_CODE)
, SSL.INDUSTRY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('INDUSTRY'
, SSL.INDUSTRY_CODE)
, SSL.SURVEY_AGE_CODE
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_AGE'
, SSL.SURVEY_AGE_CODE)
, SSL.START_DATE
, SSL.END_DATE
, SSL.DIFFERENTIAL
, SSL.CURRENCY_CODE
, SSL.MINIMUM_PAY
, SSL.MEAN_PAY
, SSL.MAXIMUM_PAY
, SSL.GRADUATE_PAY
, SSL.STARTING_PAY
, SSL.PERCENTAGE_CHANGE
, SSL.JOB_FIRST_QUARTILE
, SSL.JOB_MEDIAN_QUARTILE
, SSL.JOB_THIRD_QUARTILE
, SSL.JOB_FOURTH_QUARTILE
, SSL.MINIMUM_TOTAL_COMPENSATION
, SSL.MEAN_TOTAL_COMPENSATION
, SSL.MAXIMUM_TOTAL_COMPENSATION
, SSL.COMPNSTN_FIRST_QUARTILE
, SSL.COMPNSTN_MEDIAN_QUARTILE
, SSL.COMPNSTN_THIRD_QUARTILE
, SSL.COMPNSTN_FOURTH_QUARTILE
, '_DF:PER:PER_SALARY_SURVEY_LINES:SSL'
, SSL.SALARY_SURVEY_ID
, SSL.SALARY_SURVEY_LINE_ID
, SSL.LAST_UPDATE_DATE
, SSL.LAST_UPDATED_BY
, SSL.CREATED_BY
, SSL.CREATION_DATE
FROM PER_SALARY_SURVEY_LINES SSL WITH READ ONLY