View: PER_SALARY_SURVEY_MAPPINGS_V

Product:	PER - Human Resources
Description:	Used to support user-interface.
Implementation/DBA Data:	APPS.PER_SALARY_SURVEY_MAPPINGS_V

View Text

SELECT PSM.ROWID ROW_ID
, PSM.OBJECT_VERSION_NUMBER
, PSM.SALARY_SURVEY_MAPPING_ID
, PSM.BUSINESS_GROUP_ID
, PSM.PARENT_ID
, PSM.PARENT_TABLE_NAME
, PSM.SALARY_SURVEY_LINE_ID
, PSM.LOCATION_ID
, LOCTL.LOCATION_CODE
, PSM.GRADE_ID
, GDT.NAME
, PSM.COMPANY_AGE_CODE
, L8.MEANING
, PSM.COMPANY_ORGANIZATION_ID
, AOUTL.NAME
, L1.MEANING
, SS.SURVEY_NAME
, L2.MEANING
, L3.MEANING
, L4.MEANING
, L5.MEANING
, L9.MEANING
, L6.MEANING
, FC.NAME
, L7.MEANING
, SS.BASE_REGION
, SL.START_DATE
, SL.END_DATE
, SL.DIFFERENTIAL
, SL.MINIMUM_PAY
, SL.MEAN_PAY
, SL.MAXIMUM_PAY
, SL.GRADUATE_PAY
, SL.STARTING_PAY
, SL.PERCENTAGE_CHANGE
, SL.JOB_FIRST_QUARTILE
, SL.JOB_MEDIAN_QUARTILE
, SL.JOB_THIRD_QUARTILE
, SL.JOB_FOURTH_QUARTILE
, SL.MINIMUM_TOTAL_COMPENSATION
, SL.MEAN_TOTAL_COMPENSATION
, SL.MAXIMUM_TOTAL_COMPENSATION
, SL.COMPNSTN_FIRST_QUARTILE
, SL.COMPNSTN_MEDIAN_QUARTILE
, SL.COMPNSTN_THIRD_QUARTILE
, SL.COMPNSTN_FOURTH_QUARTILE
, PSM.ATTRIBUTE_CATEGORY
, PSM.ATTRIBUTE1
, PSM.ATTRIBUTE2
, PSM.ATTRIBUTE3
, PSM.ATTRIBUTE4
, PSM.ATTRIBUTE5
, PSM.ATTRIBUTE6
, PSM.ATTRIBUTE7
, PSM.ATTRIBUTE8
, PSM.ATTRIBUTE9
, PSM.ATTRIBUTE10
, PSM.ATTRIBUTE11
, PSM.ATTRIBUTE12
, PSM.ATTRIBUTE13
, PSM.ATTRIBUTE14
, PSM.ATTRIBUTE15
, PSM.ATTRIBUTE16
, PSM.ATTRIBUTE17
, PSM.ATTRIBUTE18
, PSM.ATTRIBUTE19
, PSM.ATTRIBUTE20
, PSM.LAST_UPDATE_DATE
, PSM.LAST_UPDATED_BY
, PSM.LAST_UPDATE_LOGIN
, PSM.CREATED_BY
, PSM.CREATION_DATE
FROM PER_SALARY_SURVEYS SS
, PER_SALARY_SURVEY_LINES SL
, PER_SALARY_SURVEY_MAPPINGS PSM
, FND_CURRENCIES_VL FC
, HR_LOOKUPS L1
, HR_LOOKUPS L2
, HR_LOOKUPS L3
, HR_LOOKUPS L4
, HR_LOOKUPS L5
, HR_LOOKUPS L6
, HR_LOOKUPS L7
, HR_LOOKUPS L8
, HR_LOOKUPS L9
, HR_ALL_ORGANIZATION_UNITS_TL AOUTL
, HR_ALL_ORGANIZATION_UNITS AOU
, HR_LOCATIONS_ALL_TL LOCTL
, HR_LOCATIONS_NO_JOIN LOC
, PER_GRADES_TL GDT
WHERE SS.SALARY_SURVEY_ID=SL.SALARY_SURVEY_ID
AND SL.SALARY_SURVEY_LINE_ID=PSM.SALARY_SURVEY_LINE_ID
AND FC.CURRENCY_CODE=SL.CURRENCY_CODE
AND L1.LOOKUP_TYPE (+) = 'SURVEY_COMPANY'
AND L1.LOOKUP_CODE (+) = SS.SURVEY_COMPANY_CODE
AND L2.LOOKUP_TYPE(+) = 'SURVEY_JOB_NAME'
AND L2.LOOKUP_CODE(+) = SL.SURVEY_JOB_NAME_CODE
AND L3.LOOKUP_TYPE(+) = 'SURVEY_REGION'
AND L3.LOOKUP_CODE(+)= SL.SURVEY_REGION_CODE
AND L4.LOOKUP_TYPE(+) = 'SURVEY_SENIORITY'
AND L4.LOOKUP_CODE(+) = SL.SURVEY_SENIORITY_CODE
AND L5.LOOKUP_TYPE(+) ='COMPANY_SIZE'
AND L5.LOOKUP_CODE(+)= SL.COMPANY_SIZE_CODE
AND L6.LOOKUP_TYPE(+) = 'INDUSTRY'
AND L6.LOOKUP_CODE(+) = SL.INDUSTRY_CODE
AND L7.LOOKUP_TYPE(+) = 'PAY_BASIS'
AND L7.LOOKUP_CODE(+) = SS.SURVEY_TYPE_CODE
AND L8.LOOKUP_TYPE(+) = 'COMPANY_AGE'
AND L8.LOOKUP_CODE(+) = PSM.COMPANY_AGE_CODE
AND L9.LOOKUP_TYPE(+) = 'SURVEY_AGE'
AND L9.LOOKUP_CODE(+) = SL.SURVEY_AGE_CODE
AND AOU.ORGANIZATION_ID (+) = PSM.COMPANY_ORGANIZATION_ID
AND AOU.BUSINESS_GROUP_ID (+) = PSM.BUSINESS_GROUP_ID
AND GDT.GRADE_ID (+) = PSM.GRADE_ID
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND LOC.LOCATION_ID (+) = PSM.LOCATION_ID
AND LOC.LOCATION_ID = LOCTL.LOCATION_ID (+)
AND AOU.ORGANIZATION_ID = AOUTL.ORGANIZATION_ID (+)
AND DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, LOCTL.LANGUAGE) = DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND DECODE(AOUTL.ORGANIZATION_ID
, NULL
, '1'
, AOUTL.LANGUAGE) = DECODE(AOUTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))

Columns