VIEW: APPS.PER_PAY_PROPOSALS_V2

Source

View Text - Preformatted

SELECT PRO.ROWID , PRO.PAY_PROPOSAL_ID , PRV.PERFORMANCE_RATING , HL2.MEANING , PRO.BUSINESS_GROUP_ID , PRO.ASSIGNMENT_ID , PRO.PERFORMANCE_REVIEW_ID , PRV.REVIEW_DATE , TO_CHAR( PRO.PROPOSED_SALARY_N) , PRO.PROPOSED_SALARY_N , PRO.CHANGE_DATE , PRO.PROPOSAL_REASON , HL1.MEANING , PRO.LAST_CHANGE_DATE , PRO.NEXT_SAL_REVIEW_DATE , PRO.FORCED_RANKING , PRO.ATTRIBUTE_CATEGORY , PRO.ATTRIBUTE1 , PRO.ATTRIBUTE2 , PRO.ATTRIBUTE3 , PRO.ATTRIBUTE4 , PRO.ATTRIBUTE5 , PRO.ATTRIBUTE6 , PRO.ATTRIBUTE7 , PRO.ATTRIBUTE8 , PRO.ATTRIBUTE9 , PRO.ATTRIBUTE10 , PRO.ATTRIBUTE11 , PRO.ATTRIBUTE12 , PRO.ATTRIBUTE13 , PRO.ATTRIBUTE14 , PRO.ATTRIBUTE15 , PRO.ATTRIBUTE16 , PRO.ATTRIBUTE17 , PRO.ATTRIBUTE18 , PRO.ATTRIBUTE19 , PRO.ATTRIBUTE20 ,PRO.MULTIPLE_COMPONENTS ,PRO.APPROVED ,PRO.COMMENTS ,PRO.OBJECT_VERSION_NUMBER ,PRO.LAST_UPDATE_DATE ,PRO.LAST_UPDATED_BY ,PRO.LAST_UPDATE_LOGIN ,PRO.CREATED_BY ,PRO.CREATION_DATE FROM HR_LOOKUPS HL1, HR_LOOKUPS HL2, PER_PERFORMANCE_REVIEWS PRV, PER_PAY_PROPOSALS PRO WHERE PRO.PERFORMANCE_REVIEW_ID=PRV.PERFORMANCE_REVIEW_ID(+) AND HL2.LOOKUP_CODE(+)=PRV.PERFORMANCE_RATING AND HL2.LOOKUP_TYPE(+)='PERFORMANCE_RATING' AND HL1.LOOKUP_CODE(+)=PRO.PROPOSAL_REASON AND HL1.LOOKUP_TYPE(+)='PROPOSAL_REASON'

View Text - HTML Formatted

SELECT PRO.ROWID
, PRO.PAY_PROPOSAL_ID
, PRV.PERFORMANCE_RATING
, HL2.MEANING
, PRO.BUSINESS_GROUP_ID
, PRO.ASSIGNMENT_ID
, PRO.PERFORMANCE_REVIEW_ID
, PRV.REVIEW_DATE
, TO_CHAR( PRO.PROPOSED_SALARY_N)
, PRO.PROPOSED_SALARY_N
, PRO.CHANGE_DATE
, PRO.PROPOSAL_REASON
, HL1.MEANING
, PRO.LAST_CHANGE_DATE
, PRO.NEXT_SAL_REVIEW_DATE
, PRO.FORCED_RANKING
, PRO.ATTRIBUTE_CATEGORY
, PRO.ATTRIBUTE1
, PRO.ATTRIBUTE2
, PRO.ATTRIBUTE3
, PRO.ATTRIBUTE4
, PRO.ATTRIBUTE5
, PRO.ATTRIBUTE6
, PRO.ATTRIBUTE7
, PRO.ATTRIBUTE8
, PRO.ATTRIBUTE9
, PRO.ATTRIBUTE10
, PRO.ATTRIBUTE11
, PRO.ATTRIBUTE12
, PRO.ATTRIBUTE13
, PRO.ATTRIBUTE14
, PRO.ATTRIBUTE15
, PRO.ATTRIBUTE16
, PRO.ATTRIBUTE17
, PRO.ATTRIBUTE18
, PRO.ATTRIBUTE19
, PRO.ATTRIBUTE20
, PRO.MULTIPLE_COMPONENTS
, PRO.APPROVED
, PRO.COMMENTS
, PRO.OBJECT_VERSION_NUMBER
, PRO.LAST_UPDATE_DATE
, PRO.LAST_UPDATED_BY
, PRO.LAST_UPDATE_LOGIN
, PRO.CREATED_BY
, PRO.CREATION_DATE
FROM HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, PER_PERFORMANCE_REVIEWS PRV
, PER_PAY_PROPOSALS PRO
WHERE PRO.PERFORMANCE_REVIEW_ID=PRV.PERFORMANCE_REVIEW_ID(+)
AND HL2.LOOKUP_CODE(+)=PRV.PERFORMANCE_RATING
AND HL2.LOOKUP_TYPE(+)='PERFORMANCE_RATING'
AND HL1.LOOKUP_CODE(+)=PRO.PROPOSAL_REASON
AND HL1.LOOKUP_TYPE(+)='PROPOSAL_REASON'