VIEW: APPS.PER_SALARY_SURVEYS_V

Source

View Text - Preformatted

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(+) = 'PQH_SURVEY_PAY_BASIS' AND HL2.LOOKUP_CODE(+)= PSS.SURVEY_TYPE_CODE

View Text - HTML Formatted

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(+) = 'PQH_SURVEY_PAY_BASIS'
AND HL2.LOOKUP_CODE(+)= PSS.SURVEY_TYPE_CODE