VIEW: APPS.PER_INFO_TYPE_SECURITY_V

Source

View Text - Preformatted

SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, PIT.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE , ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN , ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PER_PEOPLE_INFO_TYPES PIT WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = PIT.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PER_PEOPLE_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Person Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, POT.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PER_POSITION_INFO_TYPES POT WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = POT.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PER_POSITION_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Position Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, AIT.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PER_ASSIGNMENT_INFO_TYPES AIT WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = AIT.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PER_ASSIGNMENT_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Assignment Developer DF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, HRL.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, HR_LOCATION_INFO_TYPES HRL WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = HRL.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'HR_LOCATION_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Location Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, PJT.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PER_JOB_INFO_TYPES PJT WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = PJT.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PER_JOB_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Job Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, GPT.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, GHR_PA_REQUEST_INFO_TYPES GPT WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = GPT.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'GHR_PA_REQUEST_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra PA Request Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, PAY.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PAY_ELEMENT_TYPE_INFO_TYPES PAY WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = PAY.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PAY_ELEMENT_TYPE_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Element Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, JOB.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PER_PREV_JOB_INFO_TYPES JOB WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = JOB.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PER_PREV_JOB_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Previous Job DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, CON.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PER_CONTACT_INFO_TYPES CON WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = CON.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PER_CONTACT_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Contact Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, RLS.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PQH_ROLE_INFO_TYPES RLS WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PQH_ROLE_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Role Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, PVA.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PQP_VEH_ALLOC_INFO_TYPES PVA WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = PVA.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PQP_VEH_ALLOC_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Vehicle Alloc Extra Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, PVR.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, PQP_VEH_REPOS_INFO_TYPES PVR WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = PVR.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'PQP_VEH_REPOS_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Vehicle Repos Extra Info DDF' AND FLV.ENABLED_FLAG = 'Y' /* START OAB CHANGES */ UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, RLS.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, BEN_OPT_INFO_TYPES RLS WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_OPT_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Option Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, RLS.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, BEN_ABR_INFO_TYPES RLS WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_ABR_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Standard Rate Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, RLS.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, BEN_ELP_INFO_TYPES RLS WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_ELP_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Eligibility Profile Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, RLS.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, BEN_LER_INFO_TYPES RLS WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_LER_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Life Event Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, RLS.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, BEN_PGM_INFO_TYPES RLS WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_PGM_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Program Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME, RLS.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE, ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN, ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, BEN_PL_INFO_TYPES RLS WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_PL_INFO_TYPES' AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Plan Info DDF' AND FLV.ENABLED_FLAG = 'Y' /* END OAB CHANGES */ /* Start changes for DOR*/ UNION ALL SELECT DISTINCT ITS.PER_INFO_TYPE_SECURITY_ID, ITS.APPLICATION_ID, ITS.RESPONSIBILITY_ID, ITS.INFO_TYPE_TABLE_NAME, ITS.INFORMATION_TYPE, NVL(FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME,ITS.INFORMATION_TYPE), HDT.LEGISLATION_CODE, ITS.LAST_UPDATE_DATE , ITS.LAST_UPDATED_BY, ITS.LAST_UPDATE_LOGIN , ITS.CREATED_BY, ITS.CREATION_DATE, ITS.OBJECT_VERSION_NUMBER FROM PER_INFO_TYPE_SECURITY ITS, FND_DESCR_FLEX_CONTEXTS_VL FLV, HR_DOCUMENT_TYPES_V HDT WHERE ITS.INFORMATION_TYPE = HDT.SYSTEM_DOCUMENT_TYPE AND ITS.INFO_TYPE_TABLE_NAME = 'HR_DOCUMENT_TYPES_V' AND ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE (+) AND FLV.DESCRIPTIVE_FLEXFIELD_NAME (+) = 'Extra Document Info DDF' AND FLV.ENABLED_FLAG (+) = 'Y' /* End changes for DOR*/

View Text - HTML Formatted

SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, PIT.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PER_PEOPLE_INFO_TYPES PIT
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = PIT.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PER_PEOPLE_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PERSON INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, POT.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PER_POSITION_INFO_TYPES POT
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = POT.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PER_POSITION_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA POSITION INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, AIT.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PER_ASSIGNMENT_INFO_TYPES AIT
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = AIT.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PER_ASSIGNMENT_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'ASSIGNMENT DEVELOPER DF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, HRL.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, HR_LOCATION_INFO_TYPES HRL
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = HRL.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'HR_LOCATION_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA LOCATION INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, PJT.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PER_JOB_INFO_TYPES PJT
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = PJT.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PER_JOB_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA JOB INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, GPT.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, GHR_PA_REQUEST_INFO_TYPES GPT
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = GPT.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'GHR_PA_REQUEST_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PA REQUEST INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, PAY.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PAY_ELEMENT_TYPE_INFO_TYPES PAY
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = PAY.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PAY_ELEMENT_TYPE_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA ELEMENT INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, JOB.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PER_PREV_JOB_INFO_TYPES JOB
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = JOB.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PER_PREV_JOB_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PREVIOUS JOB DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, CON.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PER_CONTACT_INFO_TYPES CON
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = CON.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PER_CONTACT_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA CONTACT INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, RLS.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PQH_ROLE_INFO_TYPES RLS
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PQH_ROLE_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA ROLE INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, PVA.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PQP_VEH_ALLOC_INFO_TYPES PVA
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = PVA.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PQP_VEH_ALLOC_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'VEHICLE ALLOC EXTRA INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, PVR.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, PQP_VEH_REPOS_INFO_TYPES PVR
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = PVR.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'PQP_VEH_REPOS_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'VEHICLE REPOS EXTRA INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' /* START OAB CHANGES */ UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, RLS.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, BEN_OPT_INFO_TYPES RLS
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_OPT_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA OPTION INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, RLS.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, BEN_ABR_INFO_TYPES RLS
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_ABR_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'STANDARD RATE INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, RLS.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, BEN_ELP_INFO_TYPES RLS
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_ELP_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'ELIGIBILITY PROFILE INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, RLS.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, BEN_LER_INFO_TYPES RLS
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_LER_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA LIFE EVENT INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, RLS.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, BEN_PGM_INFO_TYPES RLS
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_PGM_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PROGRAM INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION ALL SELECT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, RLS.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, BEN_PL_INFO_TYPES RLS
WHERE ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ITS.INFORMATION_TYPE = RLS.INFORMATION_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'BEN_PL_INFO_TYPES'
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PLAN INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' /* END OAB CHANGES */ /* START CHANGES FOR DOR*/ UNION ALL SELECT DISTINCT ITS.PER_INFO_TYPE_SECURITY_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, ITS.INFO_TYPE_TABLE_NAME
, ITS.INFORMATION_TYPE
, NVL(FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, ITS.INFORMATION_TYPE)
, HDT.LEGISLATION_CODE
, ITS.LAST_UPDATE_DATE
, ITS.LAST_UPDATED_BY
, ITS.LAST_UPDATE_LOGIN
, ITS.CREATED_BY
, ITS.CREATION_DATE
, ITS.OBJECT_VERSION_NUMBER
FROM PER_INFO_TYPE_SECURITY ITS
, FND_DESCR_FLEX_CONTEXTS_VL FLV
, HR_DOCUMENT_TYPES_V HDT
WHERE ITS.INFORMATION_TYPE = HDT.SYSTEM_DOCUMENT_TYPE
AND ITS.INFO_TYPE_TABLE_NAME = 'HR_DOCUMENT_TYPES_V'
AND ITS.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE (+)
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME (+) = 'EXTRA DOCUMENT INFO DDF'
AND FLV.ENABLED_FLAG (+) = 'Y' /* END CHANGES FOR DOR*/