Product: | PER - Human Resources |
---|---|
Description: | Gets Job Group and associated flexfield information |
Implementation/DBA Data: | APPS.PER_JOB_GROUPS_V |
SELECT JGR.ROWID ROW_ID
, JGR.JOB_GROUP_ID
, JGR.BUSINESS_GROUP_ID
, ORG.NAME
, JGR.LEGISLATION_CODE
, JGR.INTERNAL_NAME
, JGR.DISPLAYED_NAME
, JGR.ID_FLEX_NUM
, FND.ID_FLEX_STRUCTURE_NAME
, JGR.MASTER_FLAG
, JGR.OBJECT_VERSION_NUMBER
, JGR.CREATION_DATE
, JGR.CREATED_BY
, JGR.LAST_UPDATE_DATE
, JGR.LAST_UPDATED_BY
, JGR.LAST_UPDATE_LOGIN
FROM PER_JOB_GROUPS JGR
, HR_ALL_ORGANIZATION_UNITS ORG
, FND_ID_FLEX_STRUCTURES_VL FND
WHERE JGR.BUSINESS_GROUP_ID = ORG.ORGANIZATION_ID (+)
AND JGR.ID_FLEX_NUM = FND.ID_FLEX_NUM
AND FND.ID_FLEX_CODE = 'JOB'