Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_PROPOSAL_COMPONENTS_V |
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