VIEW: APPS.PER_INFO_TYPES_V

Source

View Text - Preformatted

SELECT 'PER_PEOPLE_INFO_TYPES', PIT.INFORMATION_TYPE, PIT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PER_PEOPLE_INFO_TYPES PIT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE PIT.ACTIVE_INACTIVE_FLAG = 'Y' AND PIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Person Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_POSITION_INFO_TYPES', POT.INFORMATION_TYPE, POT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PER_POSITION_INFO_TYPES POT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE POT.ACTIVE_INACTIVE_FLAG = 'Y' AND POT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Position Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_ASSIGNMENT_INFO_TYPES', AIT.INFORMATION_TYPE, AIT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PER_ASSIGNMENT_INFO_TYPES AIT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE AIT.ACTIVE_INACTIVE_FLAG = 'Y' AND AIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Assignment Developer DF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'HR_LOCATION_INFO_TYPES', LIT.INFORMATION_TYPE, LIT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM HR_LOCATION_INFO_TYPES LIT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE LIT.ACTIVE_INACTIVE_FLAG = 'Y' AND LIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Location Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_JOB_INFO_TYPES', JIT.INFORMATION_TYPE, JIT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PER_JOB_INFO_TYPES JIT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE JIT.ACTIVE_INACTIVE_FLAG = 'Y' AND JIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Job Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'GHR_PA_REQUEST_INFO_TYPES', RIT.INFORMATION_TYPE, RIT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM GHR_PA_REQUEST_INFO_TYPES RIT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE RIT.ACTIVE_INACTIVE_FLAG = 'Y' AND RIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra PA Request Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PAY_ELEMENT_TYPE_INFO_TYPES', EIT.INFORMATION_TYPE, EIT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PAY_ELEMENT_TYPE_INFO_TYPES EIT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE EIT.ACTIVE_INACTIVE_FLAG = 'Y' AND EIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Element Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_PREV_JOB_INFO_TYPES', PJX.INFORMATION_TYPE, PJX.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PER_PREV_JOB_INFO_TYPES PJX, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE PJX.ACTIVE_INACTIVE_FLAG = 'Y' AND PJX.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Previous Job DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_CONTACT_INFO_TYPES', CIT.INFORMATION_TYPE, CIT.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PER_CONTACT_INFO_TYPES CIT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE CIT.ACTIVE_INACTIVE_FLAG = 'Y' AND CIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Contact Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PQH_ROLE_INFO_TYPES' table_name, rls.information_type INFORMATION_TYPE, rls.legislation_code LEGISLATION_CODE, NULL FROM pqh_role_info_types rls WHERE rls.active_inactive_flag = 'Y' UNION SELECT 'PQP_VEH_ALLOC_INFO_TYPES', PVA.INFORMATION_TYPE, PVA.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PQP_VEH_ALLOC_INFO_TYPES PVA, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE PVA.ACTIVE_INACTIVE_FLAG = 'Y' AND PVA.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Vehicle Alloc Extra Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PQP_VEH_REPOS_INFO_TYPES', PVR.INFORMATION_TYPE, PVR.LEGISLATION_CODE , FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM PQP_VEH_REPOS_INFO_TYPES PVR, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE PVR.ACTIVE_INACTIVE_FLAG = 'Y' AND PVR.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Vehicle Repos Extra Info DDF' AND FLV.ENABLED_FLAG = 'Y' /* Start of OAB Changes */ UNION SELECT 'BEN_OPT_INFO_TYPES' table_name, oit.information_type INFORMATION_TYPE, OIT.LEGISLATION_CODE LEGISLATION_CODE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM BEN_OPT_INFO_TYPES OIT , FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE OIT.ACTIVE_INACTIVE_FLAG = 'Y' and OIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Option Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_PGM_INFO_TYPES' TABLE_NAME, PIT.INFORMATION_TYPE INFORMATION_TYPE, PIT.LEGISLATION_CODE LEGISLATION_CODE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM BEN_PGM_INFO_TYPES PIT , FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE PIT.ACTIVE_INACTIVE_FLAG = 'Y' and PIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Program Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_LER_INFO_TYPES' TABLE_NAME, LRI.INFORMATION_TYPE INFORMATION_TYPE, LRI.LEGISLATION_CODE LEGISLATION_CODE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM BEN_LER_INFO_TYPES LRI , FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE LRI.ACTIVE_INACTIVE_FLAG = 'Y' and LRI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Life Event Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_ABR_INFO_TYPES' TABLE_NAME, ARI.INFORMATION_TYPE INFORMATION_TYPE, ARI.LEGISLATION_CODE LEGISLATION_CODE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM BEN_ABR_INFO_TYPES ARI , FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE ARI.ACTIVE_INACTIVE_FLAG = 'Y' and ARI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Standard Rate Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_ELP_INFO_TYPES' TABLE_NAME, ELI.INFORMATION_TYPE INFORMATION_TYPE, ELI.LEGISLATION_CODE LEGISLATION_CODE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM BEN_ELP_INFO_TYPES ELI , FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE ELI.ACTIVE_INACTIVE_FLAG = 'Y' and ELI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Eligibility Profile Info DDF' AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_PL_INFO_TYPES' TABLE_NAME, PLI.INFORMATION_TYPE INFORMATION_TYPE, PLI.LEGISLATION_CODE LEGISLATION_CODE, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME FROM BEN_PL_INFO_TYPES PLI , FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE PLI.ACTIVE_INACTIVE_FLAG = 'Y' and PLI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Plan Info DDF' AND FLV.ENABLED_FLAG = 'Y' /* End of OAB Changes */ UNION /*Start DOR changes*/ SELECT 'HR_DOCUMENT_TYPES_V', HDT.SYSTEM_DOCUMENT_TYPE, HDT.LEGISLATION_CODE , NVL(FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME,HDT.DOCUMENT_TYPE) FROM HR_DOCUMENT_TYPES_V HDT, FND_DESCR_FLEX_CONTEXTS_VL FLV WHERE HDT.ACTIVE_INACTIVE_FLAG = 'Y' AND HDT.DOCUMENT_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE (+) AND FLV.DESCRIPTIVE_FLEXFIELD_NAME (+) = 'Extra Document Info DDF' AND FLV.ENABLED_FLAG (+) = 'Y' /*End DOR changes*/

View Text - HTML Formatted

SELECT 'PER_PEOPLE_INFO_TYPES'
, PIT.INFORMATION_TYPE
, PIT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PER_PEOPLE_INFO_TYPES PIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE PIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND PIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PERSON INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_POSITION_INFO_TYPES'
, POT.INFORMATION_TYPE
, POT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PER_POSITION_INFO_TYPES POT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE POT.ACTIVE_INACTIVE_FLAG = 'Y'
AND POT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA POSITION INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_ASSIGNMENT_INFO_TYPES'
, AIT.INFORMATION_TYPE
, AIT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PER_ASSIGNMENT_INFO_TYPES AIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE AIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND AIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'ASSIGNMENT DEVELOPER DF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'HR_LOCATION_INFO_TYPES'
, LIT.INFORMATION_TYPE
, LIT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM HR_LOCATION_INFO_TYPES LIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE LIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND LIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA LOCATION INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_JOB_INFO_TYPES'
, JIT.INFORMATION_TYPE
, JIT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PER_JOB_INFO_TYPES JIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE JIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND JIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA JOB INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'GHR_PA_REQUEST_INFO_TYPES'
, RIT.INFORMATION_TYPE
, RIT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM GHR_PA_REQUEST_INFO_TYPES RIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE RIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND RIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PA REQUEST INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PAY_ELEMENT_TYPE_INFO_TYPES'
, EIT.INFORMATION_TYPE
, EIT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PAY_ELEMENT_TYPE_INFO_TYPES EIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE EIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND EIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA ELEMENT INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_PREV_JOB_INFO_TYPES'
, PJX.INFORMATION_TYPE
, PJX.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PER_PREV_JOB_INFO_TYPES PJX
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE PJX.ACTIVE_INACTIVE_FLAG = 'Y'
AND PJX.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PREVIOUS JOB DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PER_CONTACT_INFO_TYPES'
, CIT.INFORMATION_TYPE
, CIT.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PER_CONTACT_INFO_TYPES CIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE CIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND CIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA CONTACT INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PQH_ROLE_INFO_TYPES' TABLE_NAME
, RLS.INFORMATION_TYPE INFORMATION_TYPE
, RLS.LEGISLATION_CODE LEGISLATION_CODE
, NULL
FROM PQH_ROLE_INFO_TYPES RLS
WHERE RLS.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PQP_VEH_ALLOC_INFO_TYPES'
, PVA.INFORMATION_TYPE
, PVA.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PQP_VEH_ALLOC_INFO_TYPES PVA
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE PVA.ACTIVE_INACTIVE_FLAG = 'Y'
AND PVA.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'VEHICLE ALLOC EXTRA INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'PQP_VEH_REPOS_INFO_TYPES'
, PVR.INFORMATION_TYPE
, PVR.LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM PQP_VEH_REPOS_INFO_TYPES PVR
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE PVR.ACTIVE_INACTIVE_FLAG = 'Y'
AND PVR.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'VEHICLE REPOS EXTRA INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' /* START OF OAB CHANGES */ UNION SELECT 'BEN_OPT_INFO_TYPES' TABLE_NAME
, OIT.INFORMATION_TYPE INFORMATION_TYPE
, OIT.LEGISLATION_CODE LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM BEN_OPT_INFO_TYPES OIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE OIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND OIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA OPTION INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_PGM_INFO_TYPES' TABLE_NAME
, PIT.INFORMATION_TYPE INFORMATION_TYPE
, PIT.LEGISLATION_CODE LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM BEN_PGM_INFO_TYPES PIT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE PIT.ACTIVE_INACTIVE_FLAG = 'Y'
AND PIT.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PROGRAM INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_LER_INFO_TYPES' TABLE_NAME
, LRI.INFORMATION_TYPE INFORMATION_TYPE
, LRI.LEGISLATION_CODE LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM BEN_LER_INFO_TYPES LRI
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE LRI.ACTIVE_INACTIVE_FLAG = 'Y'
AND LRI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA LIFE EVENT INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_ABR_INFO_TYPES' TABLE_NAME
, ARI.INFORMATION_TYPE INFORMATION_TYPE
, ARI.LEGISLATION_CODE LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM BEN_ABR_INFO_TYPES ARI
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE ARI.ACTIVE_INACTIVE_FLAG = 'Y'
AND ARI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'STANDARD RATE INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_ELP_INFO_TYPES' TABLE_NAME
, ELI.INFORMATION_TYPE INFORMATION_TYPE
, ELI.LEGISLATION_CODE LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM BEN_ELP_INFO_TYPES ELI
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE ELI.ACTIVE_INACTIVE_FLAG = 'Y'
AND ELI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'ELIGIBILITY PROFILE INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' UNION SELECT 'BEN_PL_INFO_TYPES' TABLE_NAME
, PLI.INFORMATION_TYPE INFORMATION_TYPE
, PLI.LEGISLATION_CODE LEGISLATION_CODE
, FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
FROM BEN_PL_INFO_TYPES PLI
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE PLI.ACTIVE_INACTIVE_FLAG = 'Y'
AND PLI.INFORMATION_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME = 'EXTRA PLAN INFO DDF'
AND FLV.ENABLED_FLAG = 'Y' /* END OF OAB CHANGES */ UNION /*START DOR CHANGES*/ SELECT 'HR_DOCUMENT_TYPES_V'
, HDT.SYSTEM_DOCUMENT_TYPE
, HDT.LEGISLATION_CODE
, NVL(FLV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, HDT.DOCUMENT_TYPE)
FROM HR_DOCUMENT_TYPES_V HDT
, FND_DESCR_FLEX_CONTEXTS_VL FLV
WHERE HDT.ACTIVE_INACTIVE_FLAG = 'Y'
AND HDT.DOCUMENT_TYPE = FLV.DESCRIPTIVE_FLEX_CONTEXT_CODE (+)
AND FLV.DESCRIPTIVE_FLEXFIELD_NAME (+) = 'EXTRA DOCUMENT INFO DDF'
AND FLV.ENABLED_FLAG (+) = 'Y' /*END DOR CHANGES*/