Product: | PER - Human Resources |
---|---|
Description: | KR specific |
Implementation/DBA Data: | APPS.PER_KR_GRADE_AMOUNT |
SELECT PKGAF.ROWID
, PKGAF.GRADE_AMOUNT_ID
, PKGAF.EFFECTIVE_START_DATE
, PKGAF.EFFECTIVE_END_DATE
, PKGAF.GRADE_ID
, PKGAF.GRADE_AMOUNT
, PKGAF.OBJECT_VERSION_NUMBER
, PKGAF.LAST_UPDATE_DATE
, PKGAF.LAST_UPDATED_BY
, PKGAF.LAST_UPDATE_LOGIN
, PKGAF.CREATED_BY
, PKGAF.CREATION_DATE
, PKGAF.ATTRIBUTE_CATEGORY
, PKGAF.ATTRIBUTE1
, PKGAF.ATTRIBUTE2
, PKGAF.ATTRIBUTE3
, PKGAF.ATTRIBUTE4
, PKGAF.ATTRIBUTE5
, PKGAF.ATTRIBUTE6
, PKGAF.ATTRIBUTE7
, PKGAF.ATTRIBUTE8
, PKGAF.ATTRIBUTE9
, PKGAF.ATTRIBUTE10
, PKGAF.ATTRIBUTE11
, PKGAF.ATTRIBUTE12
, PKGAF.ATTRIBUTE13
, PKGAF.ATTRIBUTE14
, PKGAF.ATTRIBUTE15
, PKGAF.ATTRIBUTE16
, PKGAF.ATTRIBUTE17
, PKGAF.ATTRIBUTE18
, PKGAF.ATTRIBUTE19
, PKGAF.ATTRIBUTE20
, PKGAF.ATTRIBUTE21
, PKGAF.ATTRIBUTE22
, PKGAF.ATTRIBUTE23
, PKGAF.ATTRIBUTE24
, PKGAF.ATTRIBUTE25
, PKGAF.ATTRIBUTE26
, PKGAF.ATTRIBUTE27
, PKGAF.ATTRIBUTE28
, PKGAF.ATTRIBUTE29
, PKGAF.ATTRIBUTE30
FROM PER_KR_GRADE_AMOUNT_F PKGAF
WHERE PKGAF.EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE FND_SESSIONS.SESSION_ID = USERENV('SESSIONID'))
AND PKGAF.EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE FND_SESSIONS.SESSION_ID = USERENV('SESSIONID'))