View: PER_SALARY_SURVEYS_V

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

View Text

SELECT PSS.ROWID ROW_ID
, PSS.OBJECT_VERSION_NUMBER
, PSS.SALARY_SURVEY_ID
, PSS.SURVEY_NAME
, PSS.SURVEY_COMPANY_CODE
, PSS.IDENTIFIER
, PSS.SURVEY_TYPE_CODE
, HL1.MEANING
, HL2.MEANING
, PSS.BASE_REGION
, PSS.ATTRIBUTE_CATEGORY
, PSS.ATTRIBUTE1
, PSS.ATTRIBUTE2
, PSS.ATTRIBUTE3
, PSS.ATTRIBUTE4
, PSS.ATTRIBUTE5
, PSS.ATTRIBUTE6
, PSS.ATTRIBUTE7
, PSS.ATTRIBUTE8
, PSS.ATTRIBUTE9
, PSS.ATTRIBUTE10
, PSS.ATTRIBUTE11
, PSS.ATTRIBUTE12
, PSS.ATTRIBUTE13
, PSS.ATTRIBUTE14
, PSS.ATTRIBUTE15
, PSS.ATTRIBUTE16
, PSS.ATTRIBUTE17
, PSS.ATTRIBUTE18
, PSS.ATTRIBUTE19
, PSS.ATTRIBUTE20
, PSS.LAST_UPDATE_DATE
, PSS.LAST_UPDATED_BY
, PSS.LAST_UPDATE_LOGIN
, PSS.CREATED_BY
, PSS.CREATION_DATE
FROM PER_SALARY_SURVEYS PSS
, HR_LOOKUPS HL1
, HR_LOOKUPS HL2
WHERE HL1.LOOKUP_TYPE (+) = 'SURVEY_COMPANY'
AND HL1.LOOKUP_CODE (+) = PSS.SURVEY_COMPANY_CODE
AND HL2.LOOKUP_TYPE(+) = 'PAY_BASIS'
AND HL2.LOOKUP_CODE(+)= PSS.SURVEY_TYPE_CODE

Columns