Product: | PER - Human Resources |
---|---|
Description: | HR_SUMMARY_RESTRICTION_TYPE stores all restrictions that can be applied to an item type. |
Implementation/DBA Data: | APPS.HR_SUMMARY_RESTRICTION_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_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 = 'RESTRICTION_TYPE'
AND S.TEXT_VALUE1 = L.LOOKUP_CODE
AND L.APPLICATION_ID = 800
AND L.LOOKUP_TYPE = 'GSP_RESTRICTION_TYPE'