View: PER_PAY_PROPOSALS_V2

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

View Text

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'

Columns