Product: | PER - Human Resources |
---|---|
Description: | HR_SUMMARY_ITEM_TYPE will hold the name of each of the summary data items. In addition each item type stores the default SQL statement this will provide the superset of all data that should be processed within any given calculation. |
Implementation/DBA Data: | APPS.HR_SUMMARY_ITEM_TYPE |
SELECT S.ROWID
, S.ID_VALUE
, S.BUSINESS_GROUP_ID
, S.OBJECT_VERSION_NUMBER
, S.TEXT_VALUE1
, L.MEANING
, S.TEXT_VALUE2
, S.TEXT_VALUE3
, S.TEXT_VALUE4
, S.TEXT_VALUE5
, S.TEXT_VALUE6
, S.TEXT_VALUE7
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
, S.CREATED_BY
, S.CREATION_DATE
FROM HR_SUMMARY S
, HR_LOOKUPS L
WHERE S.TYPE = 'ITEM_TYPE'
AND S.TEXT_VALUE1 = L.LOOKUP_CODE
AND L.APPLICATION_ID = 800
AND L.LOOKUP_TYPE = 'GSP_ITEM_TYPE'