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