VIEW: APPS.PER_PROPOSAL_COMPONENTS_V

Source

View Text - Preformatted

SELECT PPC.ROWID , PPC.COMPONENT_ID , PPC.BUSINESS_GROUP_ID , PPC.PAY_PROPOSAL_ID , PPC.APPROVED , PPC.COMPONENT_REASON , HL.MEANING , TO_CHAR(PPC.CHANGE_AMOUNT_N) , PPC.CHANGE_AMOUNT_N , PPC.CHANGE_PERCENTAGE , TO_CHAR(PPC.CHANGE_PERCENTAGE,'FM99999999990D099') , PPC.ATTRIBUTE_CATEGORY , PPC.ATTRIBUTE1 , PPC.ATTRIBUTE2 , PPC.ATTRIBUTE3 , PPC.ATTRIBUTE4 , PPC.ATTRIBUTE5 , PPC.ATTRIBUTE6 , PPC.ATTRIBUTE7 , PPC.ATTRIBUTE8 , PPC.ATTRIBUTE9 , PPC.ATTRIBUTE10 , PPC.ATTRIBUTE11 , PPC.ATTRIBUTE12 , PPC.ATTRIBUTE13 , PPC.ATTRIBUTE14 , PPC.ATTRIBUTE15 , PPC.ATTRIBUTE16 , PPC.ATTRIBUTE17 , PPC.ATTRIBUTE18 , PPC.ATTRIBUTE19 , PPC.ATTRIBUTE20 , PPC.LAST_UPDATE_DATE , PPC.LAST_UPDATED_BY , PPC.LAST_UPDATE_LOGIN , PPC.CREATED_BY , PPC.CREATION_DATE , PPC.OBJECT_VERSION_NUMBER FROM PER_PAY_PROPOSAL_COMPONENTS PPC, HR_LOOKUPS HL WHERE HL.LOOKUP_TYPE = 'PROPOSAL_REASON' AND HL.LOOKUP_CODE = PPC.COMPONENT_REASON

View Text - HTML Formatted

SELECT PPC.ROWID
, PPC.COMPONENT_ID
, PPC.BUSINESS_GROUP_ID
, PPC.PAY_PROPOSAL_ID
, PPC.APPROVED
, PPC.COMPONENT_REASON
, HL.MEANING
, TO_CHAR(PPC.CHANGE_AMOUNT_N)
, PPC.CHANGE_AMOUNT_N
, PPC.CHANGE_PERCENTAGE
, TO_CHAR(PPC.CHANGE_PERCENTAGE
, 'FM99999999990D099')
, PPC.ATTRIBUTE_CATEGORY
, PPC.ATTRIBUTE1
, PPC.ATTRIBUTE2
, PPC.ATTRIBUTE3
, PPC.ATTRIBUTE4
, PPC.ATTRIBUTE5
, PPC.ATTRIBUTE6
, PPC.ATTRIBUTE7
, PPC.ATTRIBUTE8
, PPC.ATTRIBUTE9
, PPC.ATTRIBUTE10
, PPC.ATTRIBUTE11
, PPC.ATTRIBUTE12
, PPC.ATTRIBUTE13
, PPC.ATTRIBUTE14
, PPC.ATTRIBUTE15
, PPC.ATTRIBUTE16
, PPC.ATTRIBUTE17
, PPC.ATTRIBUTE18
, PPC.ATTRIBUTE19
, PPC.ATTRIBUTE20
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.LAST_UPDATE_LOGIN
, PPC.CREATED_BY
, PPC.CREATION_DATE
, PPC.OBJECT_VERSION_NUMBER
FROM PER_PAY_PROPOSAL_COMPONENTS PPC
, HR_LOOKUPS HL
WHERE HL.LOOKUP_TYPE = 'PROPOSAL_REASON'
AND HL.LOOKUP_CODE = PPC.COMPONENT_REASON