VIEW: APPS.PER_SALARY_SURVEY_V

Source

View Text - Preformatted

SELECT PSS.SURVEY_NAME SURVEY_NAME, PSS.IDENTIFIER IDENTIFIER, HL1.MEANING SURVEY_COMPANY, HL2.MEANING SURVEY_TYPE, PSS.BASE_REGION BASE_REGION, SSL.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID, SSL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SSL.SALARY_SURVEY_ID SALARY_SURVEY_ID, SSL.SURVEY_JOB_NAME_CODE SURVEY_JOB_NAME_CODE, SSL.SURVEY_REGION_CODE SURVEY_REGION_CODE, SSL.SURVEY_SENIORITY_CODE SURVEY_SENIORITY_CODE, SSL.COMPANY_SIZE_CODE COMPANY_SIZE_CODE, SSL.INDUSTRY_CODE INDUSTRY_CODE, SSL.SURVEY_AGE_CODE SURVEY_AGE_CODE, SSL.CURRENCY_CODE CURRENCY_CODE, HL3.MEANING SURVEY_JOB_NAME, HL4.MEANING SURVEY_REGION, HL5.MEANING SURVEY_SENIORITY, HL6.MEANING COMPANY_SIZE, HL7.MEANING INDUSTRY, HL8.MEANING SURVEY_AGE, FCL.NAME CURRENCY, SSL.START_DATE START_DATE, SSL.END_DATE END_DATE, SSL.DIFFERENTIAL DIFFERENTIAL, SSL.MINIMUM_PAY MINIMUM_PAY, SSL.MEAN_PAY MEAN_PAY, SSL.MAXIMUM_PAY MAXIMUM_PAY, SSL.GRADUATE_PAY GRADUATE_PAY, SSL.STARTING_PAY STARTING_PAY, SSL.PERCENTAGE_CHANGE PERCENTAGE_CHANGE, SSL.JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE, SSL.JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE, SSL.JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE, SSL.JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE, SSL.MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION, SSL.MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION, SSL.MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION, SSL.COMPNSTN_FIRST_QUARTILE COMPNSTN_FIRST_QUARTILE, SSL.COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE, SSL.COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE, SSL.COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE, SSL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, SSL.ATTRIBUTE1 ATTRIBUTE1, SSL.ATTRIBUTE2 ATTRIBUTE2, SSL.ATTRIBUTE3 ATTRIBUTE3, SSL.ATTRIBUTE4 ATTRIBUTE4, SSL.ATTRIBUTE5 ATTRIBUTE5, SSL.ATTRIBUTE6 ATTRIBUTE6, SSL.ATTRIBUTE7 ATTRIBUTE7, SSL.ATTRIBUTE8 ATTRIBUTE8, SSL.ATTRIBUTE9 ATTRIBUTE9, SSL.ATTRIBUTE10 ATTRIBUTE10, SSL.ATTRIBUTE11 ATTRIBUTE11, SSL.ATTRIBUTE12 ATTRIBUTE12, SSL.ATTRIBUTE13 ATTRIBUTE13, SSL.ATTRIBUTE14 ATTRIBUTE14, SSL.ATTRIBUTE15 ATTRIBUTE15, SSL.ATTRIBUTE16 ATTRIBUTE16, SSL.ATTRIBUTE17 ATTRIBUTE17, SSL.ATTRIBUTE18 ATTRIBUTE18, SSL.ATTRIBUTE19 ATTRIBUTE19, SSL.ATTRIBUTE20 ATTRIBUTE20, SSL.ATTRIBUTE21 ATTRIBUTE21, SSL.ATTRIBUTE22 ATTRIBUTE22, SSL.ATTRIBUTE23 ATTRIBUTE23, SSL.ATTRIBUTE24 ATTRIBUTE24, SSL.ATTRIBUTE25 ATTRIBUTE25, SSL.ATTRIBUTE26 ATTRIBUTE26, SSL.ATTRIBUTE27 ATTRIBUTE27, SSL.ATTRIBUTE28 ATTRIBUTE28, SSL.ATTRIBUTE29 ATTRIBUTE29, SSL.ATTRIBUTE30 ATTRIBUTE30, SSL.TENTH_PERCENTILE TENTH_PERCENTILE, SSL.TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE, SSL.FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE, SSL.SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE, SSL.NINETIETH_PERCENTILE NINETIETH_PERCENTILE, SSL.MINIMUM_BONUS MINIMUM_BONUS, SSL.MEAN_BONUS MEAN_BONUS, SSL.MAXIMUM_BONUS MAXIMUM_BONUS, SSL.MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE, SSL.MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE, SSL.MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE, SSL.MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION, SSL.MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION, SSL.MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION, HL9.MEANING STOCK_DISPLAY_TYPE, SSL.MINIMUM_STOCK MINIMUM_STOCK, SSL.MEAN_STOCK MEAN_STOCK, SSL.MAXIMUM_STOCK MAXIMUM_STOCK, SSL.LAST_UPDATE_DATE LAST_UPDATE_DATE, SSL.LAST_UPDATED_BY LAST_UPDATED_BY, SSL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SSL.CREATED_BY CREATED_BY, SSL.CREATION_DATE CREATION_DATE, SSL.ROWID ROW_ID, SSL.STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE_CODE FROM PER_SALARY_SURVEYS PSS, HR_LOOKUPS HL1 ,HR_LOOKUPS HL2, PER_SALARY_SURVEY_LINES SSL, HR_LOOKUPS HL3 ,HR_LOOKUPS HL4 ,HR_LOOKUPS HL5 ,HR_LOOKUPS HL6 ,HR_LOOKUPS HL7 ,HR_LOOKUPS HL8 , HR_LOOKUPS HL9, FND_CURRENCIES_TL FCL WHERE HL1.LOOKUP_TYPE (+) = 'SURVEY_COMPANY' AND HL1.LOOKUP_CODE (+) = PSS.SURVEY_COMPANY_CODE AND HL2.LOOKUP_TYPE(+) = 'PQH_SURVEY_PAY_BASIS' AND HL2.LOOKUP_CODE(+)= PSS.SURVEY_TYPE_CODE AND HL3.LOOKUP_TYPE (+) = 'SURVEY_JOB_NAME' AND HL3.LOOKUP_CODE (+) = SSL.SURVEY_JOB_NAME_CODE AND HL4.LOOKUP_TYPE(+) = 'SURVEY_REGION' AND HL4.LOOKUP_CODE(+) = SSL.SURVEY_REGION_CODE AND HL5.LOOKUP_TYPE(+) ='SURVEY_SENIORITY' AND HL5.LOOKUP_CODE(+)= SSL.SURVEY_SENIORITY_CODE AND HL6.LOOKUP_TYPE(+) = 'COMPANY_SIZE' AND HL6.LOOKUP_CODE(+) = SSL.COMPANY_SIZE_CODE AND HL7.LOOKUP_TYPE(+) ='INDUSTRY' AND HL7.LOOKUP_CODE(+)= SSL.INDUSTRY_CODE AND HL8.LOOKUP_TYPE(+) ='SURVEY_AGE' AND HL8.LOOKUP_CODE(+)= SSL.SURVEY_AGE_CODE AND HL9.LOOKUP_TYPE(+) ='STOCK_DISPLAY_TYPE' AND HL9.LOOKUP_CODE(+)= SSL.STOCK_DISPLAY_TYPE AND FCL.CURRENCY_CODE(+)= SSL.CURRENCY_CODE AND FCL.LANGUAGE = USERENV('LANG') AND PSS.SALARY_SURVEY_ID = SSL.SALARY_SURVEY_ID

View Text - HTML Formatted

SELECT PSS.SURVEY_NAME SURVEY_NAME
, PSS.IDENTIFIER IDENTIFIER
, HL1.MEANING SURVEY_COMPANY
, HL2.MEANING SURVEY_TYPE
, PSS.BASE_REGION BASE_REGION
, SSL.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID
, SSL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SSL.SALARY_SURVEY_ID SALARY_SURVEY_ID
, SSL.SURVEY_JOB_NAME_CODE SURVEY_JOB_NAME_CODE
, SSL.SURVEY_REGION_CODE SURVEY_REGION_CODE
, SSL.SURVEY_SENIORITY_CODE SURVEY_SENIORITY_CODE
, SSL.COMPANY_SIZE_CODE COMPANY_SIZE_CODE
, SSL.INDUSTRY_CODE INDUSTRY_CODE
, SSL.SURVEY_AGE_CODE SURVEY_AGE_CODE
, SSL.CURRENCY_CODE CURRENCY_CODE
, HL3.MEANING SURVEY_JOB_NAME
, HL4.MEANING SURVEY_REGION
, HL5.MEANING SURVEY_SENIORITY
, HL6.MEANING COMPANY_SIZE
, HL7.MEANING INDUSTRY
, HL8.MEANING SURVEY_AGE
, FCL.NAME CURRENCY
, SSL.START_DATE START_DATE
, SSL.END_DATE END_DATE
, SSL.DIFFERENTIAL DIFFERENTIAL
, SSL.MINIMUM_PAY MINIMUM_PAY
, SSL.MEAN_PAY MEAN_PAY
, SSL.MAXIMUM_PAY MAXIMUM_PAY
, SSL.GRADUATE_PAY GRADUATE_PAY
, SSL.STARTING_PAY STARTING_PAY
, SSL.PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, SSL.JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE
, SSL.JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE
, SSL.JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE
, SSL.JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE
, SSL.MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION
, SSL.MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION
, SSL.MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION
, SSL.COMPNSTN_FIRST_QUARTILE COMPNSTN_FIRST_QUARTILE
, SSL.COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE
, SSL.COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE
, SSL.COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE
, SSL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SSL.ATTRIBUTE1 ATTRIBUTE1
, SSL.ATTRIBUTE2 ATTRIBUTE2
, SSL.ATTRIBUTE3 ATTRIBUTE3
, SSL.ATTRIBUTE4 ATTRIBUTE4
, SSL.ATTRIBUTE5 ATTRIBUTE5
, SSL.ATTRIBUTE6 ATTRIBUTE6
, SSL.ATTRIBUTE7 ATTRIBUTE7
, SSL.ATTRIBUTE8 ATTRIBUTE8
, SSL.ATTRIBUTE9 ATTRIBUTE9
, SSL.ATTRIBUTE10 ATTRIBUTE10
, SSL.ATTRIBUTE11 ATTRIBUTE11
, SSL.ATTRIBUTE12 ATTRIBUTE12
, SSL.ATTRIBUTE13 ATTRIBUTE13
, SSL.ATTRIBUTE14 ATTRIBUTE14
, SSL.ATTRIBUTE15 ATTRIBUTE15
, SSL.ATTRIBUTE16 ATTRIBUTE16
, SSL.ATTRIBUTE17 ATTRIBUTE17
, SSL.ATTRIBUTE18 ATTRIBUTE18
, SSL.ATTRIBUTE19 ATTRIBUTE19
, SSL.ATTRIBUTE20 ATTRIBUTE20
, SSL.ATTRIBUTE21 ATTRIBUTE21
, SSL.ATTRIBUTE22 ATTRIBUTE22
, SSL.ATTRIBUTE23 ATTRIBUTE23
, SSL.ATTRIBUTE24 ATTRIBUTE24
, SSL.ATTRIBUTE25 ATTRIBUTE25
, SSL.ATTRIBUTE26 ATTRIBUTE26
, SSL.ATTRIBUTE27 ATTRIBUTE27
, SSL.ATTRIBUTE28 ATTRIBUTE28
, SSL.ATTRIBUTE29 ATTRIBUTE29
, SSL.ATTRIBUTE30 ATTRIBUTE30
, SSL.TENTH_PERCENTILE TENTH_PERCENTILE
, SSL.TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE
, SSL.FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE
, SSL.SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE
, SSL.NINETIETH_PERCENTILE NINETIETH_PERCENTILE
, SSL.MINIMUM_BONUS MINIMUM_BONUS
, SSL.MEAN_BONUS MEAN_BONUS
, SSL.MAXIMUM_BONUS MAXIMUM_BONUS
, SSL.MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE
, SSL.MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE
, SSL.MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE
, SSL.MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION
, SSL.MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION
, SSL.MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION
, HL9.MEANING STOCK_DISPLAY_TYPE
, SSL.MINIMUM_STOCK MINIMUM_STOCK
, SSL.MEAN_STOCK MEAN_STOCK
, SSL.MAXIMUM_STOCK MAXIMUM_STOCK
, SSL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SSL.LAST_UPDATED_BY LAST_UPDATED_BY
, SSL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SSL.CREATED_BY CREATED_BY
, SSL.CREATION_DATE CREATION_DATE
, SSL.ROWID ROW_ID
, SSL.STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE_CODE
FROM PER_SALARY_SURVEYS PSS
, HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, PER_SALARY_SURVEY_LINES SSL
, HR_LOOKUPS HL3
, HR_LOOKUPS HL4
, HR_LOOKUPS HL5
, HR_LOOKUPS HL6
, HR_LOOKUPS HL7
, HR_LOOKUPS HL8
, HR_LOOKUPS HL9
, FND_CURRENCIES_TL FCL
WHERE HL1.LOOKUP_TYPE (+) = 'SURVEY_COMPANY'
AND HL1.LOOKUP_CODE (+) = PSS.SURVEY_COMPANY_CODE
AND HL2.LOOKUP_TYPE(+) = 'PQH_SURVEY_PAY_BASIS'
AND HL2.LOOKUP_CODE(+)= PSS.SURVEY_TYPE_CODE
AND HL3.LOOKUP_TYPE (+) = 'SURVEY_JOB_NAME'
AND HL3.LOOKUP_CODE (+) = SSL.SURVEY_JOB_NAME_CODE
AND HL4.LOOKUP_TYPE(+) = 'SURVEY_REGION'
AND HL4.LOOKUP_CODE(+) = SSL.SURVEY_REGION_CODE
AND HL5.LOOKUP_TYPE(+) ='SURVEY_SENIORITY'
AND HL5.LOOKUP_CODE(+)= SSL.SURVEY_SENIORITY_CODE
AND HL6.LOOKUP_TYPE(+) = 'COMPANY_SIZE'
AND HL6.LOOKUP_CODE(+) = SSL.COMPANY_SIZE_CODE
AND HL7.LOOKUP_TYPE(+) ='INDUSTRY'
AND HL7.LOOKUP_CODE(+)= SSL.INDUSTRY_CODE
AND HL8.LOOKUP_TYPE(+) ='SURVEY_AGE'
AND HL8.LOOKUP_CODE(+)= SSL.SURVEY_AGE_CODE
AND HL9.LOOKUP_TYPE(+) ='STOCK_DISPLAY_TYPE'
AND HL9.LOOKUP_CODE(+)= SSL.STOCK_DISPLAY_TYPE
AND FCL.CURRENCY_CODE(+)= SSL.CURRENCY_CODE
AND FCL.LANGUAGE = USERENV('LANG')
AND PSS.SALARY_SURVEY_ID = SSL.SALARY_SURVEY_ID