eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PER_COLL_AGREE_GRADES_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_COLL_AGREE_GRADES_V

View Text

SELECT CGS.ROWID
, CA.NAME
, CA.BUSINESS_GROUP_ID
, FX.ID_FLEX_STRUCTURE_NAME
, CGS.COLLECTIVE_AGREEMENT_ID
, CGS.CAGR_GRADE_STRUCTURE_ID
, CGS.ID_FLEX_NUM
, CGS.DYNAMIC_INSERT_ALLOWED
, CGS.ATTRIBUTE_CATEGORY
, CGS.ATTRIBUTE1
, CGS.ATTRIBUTE2
, CGS.ATTRIBUTE3
, CGS.ATTRIBUTE4
, CGS.ATTRIBUTE5
, CGS.ATTRIBUTE6
, CGS.ATTRIBUTE7
, CGS.ATTRIBUTE8
, CGS.ATTRIBUTE9
, CGS.ATTRIBUTE10
, CGS.ATTRIBUTE11
, CGS.ATTRIBUTE12
, CGS.ATTRIBUTE13
, CGS.ATTRIBUTE14
, CGS.ATTRIBUTE15
, CGS.ATTRIBUTE16
, CGS.ATTRIBUTE17
, CGS.ATTRIBUTE18
, CGS.ATTRIBUTE19
, CGS.ATTRIBUTE20
, CGS.OBJECT_VERSION_NUMBER
, CGS.LAST_UPDATE_DATE
, CGS.LAST_UPDATED_BY
, CGS.LAST_UPDATE_LOGIN
, CGS.CREATED_BY
, CGS.CREATION_DATE
FROM FND_ID_FLEX_STRUCTURES_VL FX
, PER_COLLECTIVE_AGREEMENTS CA
, PER_CAGR_GRADE_STRUCTURES CGS
WHERE CGS.COLLECTIVE_AGREEMENT_ID = CA.COLLECTIVE_AGREEMENT_ID
AND CGS.ID_FLEX_NUM = FX.ID_FLEX_NUM
AND FX.ID_FLEX_CODE= 'CAGR'
AND FX.APPLICATION_ID = 800

Columns

Name
ROW_ID
CA_NAME
BUSINESS_GROUP_ID
D_GRADE_TYPE_NAME
COLLECTIVE_AGREEMENT_ID
CAGR_GRADE_STRUCTURE_ID
ID_FLEX_NUM
DYNAMIC_INSERT_ALLOWED
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE