Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface for MLS |
Implementation/DBA Data: | APPS.HR_ORG_UNITS_NO_JOIN |
SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, COST_ALLOCATION_KEYFLEX_ID
, LOCATION_ID
, NAME
, SOFT_CODING_KEYFLEX_ID
, DATE_FROM
, COMMENTS
, DATE_TO
, INTERNAL_EXTERNAL_FLAG
, INTERNAL_ADDRESS_LINE
, TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR_ALL_ORGANIZATION_UNITS HAO
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HAO.ORGANIZATION_ID)) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HAO.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HAO.BUSINESS_GROUP_ID