Product: | PER - Human Resources |
---|---|
Description: | Used to support user-interface. |
Implementation/DBA Data: | APPS.PER_SALARY_SURVEY_LINES_V |
SELECT SSL.ROWID ROW_ID
, SSL.SALARY_SURVEY_LINE_ID
, SSL.OBJECT_VERSION_NUMBER
, SSL.SALARY_SURVEY_ID
, SSL.SURVEY_JOB_NAME_CODE
, SSL.SURVEY_REGION_CODE
, SSL.SURVEY_SENIORITY_CODE
, SSL.COMPANY_SIZE_CODE
, SSL.INDUSTRY_CODE
, SSL.SURVEY_AGE_CODE
, SSL.CURRENCY_CODE
, HL1.MEANING
, HL2.MEANING
, HL3.MEANING
, HL4.MEANING
, HL5.MEANING
, HL6.MEANING
, FCV.NAME
, SSL.START_DATE
, SSL.END_DATE
, SSL.DIFFERENTIAL
, 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
, SSL.ATTRIBUTE_CATEGORY
, SSL.ATTRIBUTE1
, SSL.ATTRIBUTE2
, SSL.ATTRIBUTE3
, SSL.ATTRIBUTE4
, SSL.ATTRIBUTE5
, SSL.ATTRIBUTE6
, SSL.ATTRIBUTE7
, SSL.ATTRIBUTE8
, SSL.ATTRIBUTE9
, SSL.ATTRIBUTE10
, SSL.ATTRIBUTE11
, SSL.ATTRIBUTE12
, SSL.ATTRIBUTE13
, SSL.ATTRIBUTE14
, SSL.ATTRIBUTE15
, SSL.ATTRIBUTE16
, SSL.ATTRIBUTE17
, SSL.ATTRIBUTE18
, SSL.ATTRIBUTE19
, SSL.ATTRIBUTE20
, SSL.LAST_UPDATE_DATE
, SSL.LAST_UPDATED_BY
, SSL.LAST_UPDATE_LOGIN
, SSL.CREATED_BY
, SSL.CREATION_DATE
FROM PER_SALARY_SURVEY_LINES SSL
, HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, HR_LOOKUPS HL3
, HR_LOOKUPS HL4
, HR_LOOKUPS HL5
, HR_LOOKUPS HL6
, FND_CURRENCIES_VL FCV
WHERE HL1.LOOKUP_TYPE (+) = 'SURVEY_JOB_NAME'
AND HL1.LOOKUP_CODE (+) = SSL.SURVEY_JOB_NAME_CODE
AND HL2.LOOKUP_TYPE(+) = 'SURVEY_REGION'
AND HL2.LOOKUP_CODE(+) = SSL.SURVEY_REGION_CODE
AND HL3.LOOKUP_TYPE(+) ='SURVEY_SENIORITY'
AND HL3.LOOKUP_CODE(+)= SSL.SURVEY_SENIORITY_CODE
AND HL4.LOOKUP_TYPE(+) = 'COMPANY_SIZE'
AND HL4.LOOKUP_CODE(+) = SSL.COMPANY_SIZE_CODE
AND HL5.LOOKUP_TYPE(+) ='INDUSTRY'
AND HL5.LOOKUP_CODE(+)= SSL.INDUSTRY_CODE
AND HL6.LOOKUP_TYPE(+) ='SURVEY_AGE'
AND HL6.LOOKUP_CODE(+)= SSL.SURVEY_AGE_CODE
AND FCV.CURRENCY_CODE(+)= SSL.CURRENCY_CODE