ANC_ABSENCE_TYPES

Details

Schema: FUSION
Object owner: ANC
Object type: VIEW

Columns

Name
ABSENCE_TYPE_ID DUR_CALC_BASIS ANC_ABSENCE_TYPES_F_ALTCD CREATED_BY CREATION_DATE DURATION_UOM_CD EFFECTIVE_END_DATE EFFECTIVE_START_DATE ENTERPRISE_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID MAX_DURATION MAX_DURATION_RULE_CD MIN_DURATION MIN_DURATION_RULE_CD OBJECT_VERSION_NUMBER PARTIAL_DAY PARTIAL_DAY_FORMULA_ID ABSENCE_PATTERN_ID MANAGEMENT_TYPE_CD STATUS MAP_EVENT_TYPE_CD EMP_LOCK_IF_CONFIRM_CD MGR_LOCK_IF_CONFIRM_CD MGR_ALLOW_UPDATES_CD EMP_ALLOW_UPDATES_CD ADMIN_ALLOW_UPDATES_CD LINKAGE_RULE_CD LINKAGE_UOM_CD LINKAGE_REASON_CD LINKAGE_DURATION NAME LANGUAGE DESCRIPTION TIMECARD_AVAIL_FLAG TIMEKEEPER_AVAIL_FLAG SPL_CONDITION PATTERN_CD BEN_ELIG_PROFILE_ID ABSENCE_DURATION_FORMULA_ID ABSENCE_VALIDATION_FORMULA_ID EXCLUSION_FORMULA_ID LINKAGE_START_RULE_CD CHILD_EVENT_TYPE_CD INFORMATION_CATEGORY INFORMATION1 INFORMATION2 INFORMATION3 INFORMATION4 INFORMATION5 INFORMATION6 INFORMATION7 INFORMATION8 INFORMATION9 INFORMATION10 INFORMATION11 INFORMATION12 INFORMATION13 INFORMATION14 INFORMATION15 INFORMATION16 INFORMATION17 INFORMATION18 INFORMATION19 INFORMATION20 INFORMATION21 INFORMATION22 INFORMATION23 INFORMATION24 INFORMATION25 INFORMATION26 INFORMATION27 INFORMATION28 INFORMATION29 INFORMATION30 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 INFORMATION_NUMBER2 INFORMATION_NUMBER1 INFORMATION_NUMBER3 INFORMATION_NUMBER4 INFORMATION_NUMBER5 INFORMATION_NUMBER6 INFORMATION_NUMBER7 INFORMATION_NUMBER8 INFORMATION_NUMBER9 INFORMATION_NUMBER10 INFORMATION_NUMBER11 INFORMATION_NUMBER12 INFORMATION_NUMBER13 INFORMATION_NUMBER14 INFORMATION_NUMBER15 INFORMATION_NUMBER16 INFORMATION_NUMBER17 INFORMATION_NUMBER18 INFORMATION_NUMBER19 INFORMATION_NUMBER20 INFORMATION_DATE1 INFORMATION_DATE2 INFORMATION_DATE3 INFORMATION_DATE4 INFORMATION_DATE5 INFORMATION_DATE6 INFORMATION_DATE7 INFORMATION_DATE8 INFORMATION_DATE9 INFORMATION_DATE10 INFORMATION_DATE11 INFORMATION_DATE12 INFORMATION_DATE13 INFORMATION_DATE14 INFORMATION_DATE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 ANC_CHAR1 ANC_CHAR2 ANC_CHAR3 ANC_CHAR4 ANC_CHAR5 ANC_NUMBER1 ANC_NUMBER2 ANC_NUMBER3 ANC_NUMBER4 ANC_NUMBER5 ANC_DATE1 ANC_DATE2 ANC_DATE3 ANC_DATE4 ANC_DATE5 MODULE_ID SOURCE_LANG LEG_GROUPING_CD AGREEMENT_FLAG OTBI_DLY_BREAKDOWN BASE_NAME SGUID INCL_OPENEND_ABS_EVAL EVAL_PERIOD EVAL_EXTN_PERIOD ATTACH_TYPE ATTACH_DURATION_FLAG ATTACH_ADMIN_FLAG ATTACH_EMP_FLAG ATTACH_MGR_FLAG ATTACH_DURATION_PERIOD APPROVAL_ROUTING_CD BASIC_ASSIGNMENT_FLAG PREVENT_MULTIPLE_ASG_FLAG DISP_BAL_APRVL_NOTIFIY BIDDING_ENABLED_FLAG DISPLAY_SEQUENCE

Name

ABSENCE_TYPE_ID

DUR_CALC_BASIS

ANC_ABSENCE_TYPES_F_ALTCD

CREATED_BY

CREATION_DATE

DURATION_UOM_CD

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

ENTERPRISE_ID

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

LEGISLATION_CODE

LEGISLATIVE_DATA_GROUP_ID

MAX_DURATION

MAX_DURATION_RULE_CD

MIN_DURATION

MIN_DURATION_RULE_CD

OBJECT_VERSION_NUMBER

PARTIAL_DAY

PARTIAL_DAY_FORMULA_ID

ABSENCE_PATTERN_ID

MANAGEMENT_TYPE_CD

STATUS

MAP_EVENT_TYPE_CD

EMP_LOCK_IF_CONFIRM_CD

MGR_LOCK_IF_CONFIRM_CD

MGR_ALLOW_UPDATES_CD

EMP_ALLOW_UPDATES_CD

ADMIN_ALLOW_UPDATES_CD

LINKAGE_RULE_CD

LINKAGE_UOM_CD

LINKAGE_REASON_CD

LINKAGE_DURATION

NAME

LANGUAGE

DESCRIPTION

TIMECARD_AVAIL_FLAG

TIMEKEEPER_AVAIL_FLAG

SPL_CONDITION

PATTERN_CD

BEN_ELIG_PROFILE_ID

ABSENCE_DURATION_FORMULA_ID

ABSENCE_VALIDATION_FORMULA_ID

EXCLUSION_FORMULA_ID

LINKAGE_START_RULE_CD

CHILD_EVENT_TYPE_CD

INFORMATION_CATEGORY

INFORMATION1

INFORMATION2

INFORMATION3

INFORMATION4

INFORMATION5

INFORMATION6

INFORMATION7

INFORMATION8

INFORMATION9

INFORMATION10

INFORMATION11

INFORMATION12

INFORMATION13

INFORMATION14

INFORMATION15

INFORMATION16

INFORMATION17

INFORMATION18

INFORMATION19

INFORMATION20

INFORMATION21

INFORMATION22

INFORMATION23

INFORMATION24

INFORMATION25

INFORMATION26

INFORMATION27

INFORMATION28

INFORMATION29

INFORMATION30

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

INFORMATION_NUMBER2

INFORMATION_NUMBER1

INFORMATION_NUMBER3

INFORMATION_NUMBER4

INFORMATION_NUMBER5

INFORMATION_NUMBER6

INFORMATION_NUMBER7

INFORMATION_NUMBER8

INFORMATION_NUMBER9

INFORMATION_NUMBER10

INFORMATION_NUMBER11

INFORMATION_NUMBER12

INFORMATION_NUMBER13

INFORMATION_NUMBER14

INFORMATION_NUMBER15

INFORMATION_NUMBER16

INFORMATION_NUMBER17

INFORMATION_NUMBER18

INFORMATION_NUMBER19

INFORMATION_NUMBER20

INFORMATION_DATE1

INFORMATION_DATE2

INFORMATION_DATE3

INFORMATION_DATE4

INFORMATION_DATE5

INFORMATION_DATE6

INFORMATION_DATE7

INFORMATION_DATE8

INFORMATION_DATE9

INFORMATION_DATE10

INFORMATION_DATE11

INFORMATION_DATE12

INFORMATION_DATE13

INFORMATION_DATE14

INFORMATION_DATE15

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_NUMBER16

ATTRIBUTE_NUMBER17

ATTRIBUTE_NUMBER18

ATTRIBUTE_NUMBER19

ATTRIBUTE_NUMBER20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

ANC_CHAR1

ANC_CHAR2

ANC_CHAR3

ANC_CHAR4

ANC_CHAR5

ANC_NUMBER1

ANC_NUMBER2

ANC_NUMBER3

ANC_NUMBER4

ANC_NUMBER5

ANC_DATE1

ANC_DATE2

ANC_DATE3

ANC_DATE4

ANC_DATE5

MODULE_ID

SOURCE_LANG

LEG_GROUPING_CD

AGREEMENT_FLAG

OTBI_DLY_BREAKDOWN

BASE_NAME

SGUID

INCL_OPENEND_ABS_EVAL

EVAL_PERIOD

EVAL_EXTN_PERIOD

ATTACH_TYPE

ATTACH_DURATION_FLAG

ATTACH_ADMIN_FLAG

ATTACH_EMP_FLAG

ATTACH_MGR_FLAG

ATTACH_DURATION_PERIOD

APPROVAL_ROUTING_CD

BASIC_ASSIGNMENT_FLAG

PREVENT_MULTIPLE_ASG_FLAG

DISP_BAL_APRVL_NOTIFIY

BIDDING_ENABLED_FLAG

DISPLAY_SEQUENCE

Query

SQL_Statement
SELECT AbsenceTypesDEO.ABSENCE_TYPE_ID, AbsenceTypesDEO.DUR_CALC_BASIS, AbsenceTypesDEO.ANC_ABSENCE_TYPES_F_ALTCD, AbsenceTypesDEO.CREATED_BY, AbsenceTypesDEO.CREATION_DATE, AbsenceTypesDEO.DURATION_UOM_CD, AbsenceTypesDEO.EFFECTIVE_END_DATE, AbsenceTypesDEO.EFFECTIVE_START_DATE, AbsenceTypesDEO.ENTERPRISE_ID, AbsenceTypesDEO.LAST_UPDATE_DATE, AbsenceTypesDEO.LAST_UPDATE_LOGIN, AbsenceTypesDEO.LAST_UPDATED_BY, AbsenceTypesDEO.LEGISLATION_CODE, AbsenceTypesDEO.LEGISLATIVE_DATA_GROUP_ID, AbsenceTypesDEO.MAX_DURATION, AbsenceTypesDEO.MAX_DURATION_RULE_CD, AbsenceTypesDEO.MIN_DURATION, AbsenceTypesDEO.MIN_DURATION_RULE_CD, AbsenceTypesDEO.OBJECT_VERSION_NUMBER, AbsenceTypesDEO.PARTIAL_DAY, AbsenceTypesDEO.PARTIAL_DAY_FORMULA_ID, AbsenceTypesDEO.ABSENCE_PATTERN_ID, AbsenceTypesDEO.MANAGEMENT_TYPE_CD, AbsenceTypesDEO.STATUS, AbsenceTypesDEO.MAP_EVENT_TYPE_CD, AbsenceTypesDEO.EMP_LOCK_IF_CONFIRM_CD, AbsenceTypesDEO.MGR_LOCK_IF_CONFIRM_CD, AbsenceTypesDEO.MGR_ALLOW_UPDATES_CD, AbsenceTypesDEO.EMP_ALLOW_UPDATES_CD, AbsenceTypesDEO.ADMIN_ALLOW_UPDATES_CD, AbsenceTypesDEO.LINKAGE_RULE_CD, AbsenceTypesDEO.LINKAGE_UOM_CD, AbsenceTypesDEO.LINKAGE_REASON_CD, AbsenceTypesDEO.LINKAGE_DURATION, AbsenceTypesTranslationDEO.NAME, AbsenceTypesTranslationDEO.LANGUAGE, AbsenceTypesTranslationDEO.DESCRIPTION, AbsenceTypesDEO.TIMECARD_AVAIL_FLAG, AbsenceTypesDEO.TIMEKEEPER_AVAIL_FLAG, AbsenceTypesDEO.SPL_CONDITION, AbsenceTypesDEO.PATTERN_CD, AbsenceTypesDEO.BEN_ELIG_PROFILE_ID, AbsenceTypesDEO.ABSENCE_DURATION_FORMULA_ID, AbsenceTypesDEO.ABSENCE_VALIDATION_FORMULA_ID, AbsenceTypesDEO.EXCLUSION_FORMULA_ID, AbsenceTypesDEO.LINKAGE_START_RULE_CD, AbsenceTypesDEO.CHILD_EVENT_TYPE_CD, AbsenceTypesDEO.INFORMATION_CATEGORY, AbsenceTypesDEO.INFORMATION1, AbsenceTypesDEO.INFORMATION2, AbsenceTypesDEO.INFORMATION3, AbsenceTypesDEO.INFORMATION4, AbsenceTypesDEO.INFORMATION5, AbsenceTypesDEO.INFORMATION6, AbsenceTypesDEO.INFORMATION7, AbsenceTypesDEO.INFORMATION8, AbsenceTypesDEO.INFORMATION9, AbsenceTypesDEO.INFORMATION10, AbsenceTypesDEO.INFORMATION11, AbsenceTypesDEO.INFORMATION12, AbsenceTypesDEO.INFORMATION13, AbsenceTypesDEO.INFORMATION14, AbsenceTypesDEO.INFORMATION15, AbsenceTypesDEO.INFORMATION16, AbsenceTypesDEO.INFORMATION17, AbsenceTypesDEO.INFORMATION18, AbsenceTypesDEO.INFORMATION19, AbsenceTypesDEO.INFORMATION20, AbsenceTypesDEO.INFORMATION21, AbsenceTypesDEO.INFORMATION22, AbsenceTypesDEO.INFORMATION23, AbsenceTypesDEO.INFORMATION24, AbsenceTypesDEO.INFORMATION25, AbsenceTypesDEO.INFORMATION26, AbsenceTypesDEO.INFORMATION27, AbsenceTypesDEO.INFORMATION28, AbsenceTypesDEO.INFORMATION29, AbsenceTypesDEO.INFORMATION30, AbsenceTypesDEO.ATTRIBUTE_CATEGORY, AbsenceTypesDEO.ATTRIBUTE1, AbsenceTypesDEO.ATTRIBUTE2, AbsenceTypesDEO.ATTRIBUTE3, AbsenceTypesDEO.ATTRIBUTE4, AbsenceTypesDEO.ATTRIBUTE5, AbsenceTypesDEO.ATTRIBUTE6, AbsenceTypesDEO.ATTRIBUTE7, AbsenceTypesDEO.ATTRIBUTE8, AbsenceTypesDEO.ATTRIBUTE9, AbsenceTypesDEO.ATTRIBUTE10, AbsenceTypesDEO.ATTRIBUTE11, AbsenceTypesDEO.ATTRIBUTE12, AbsenceTypesDEO.ATTRIBUTE13, AbsenceTypesDEO.ATTRIBUTE14, AbsenceTypesDEO.ATTRIBUTE15, AbsenceTypesDEO.ATTRIBUTE16, AbsenceTypesDEO.ATTRIBUTE17, AbsenceTypesDEO.ATTRIBUTE18, AbsenceTypesDEO.ATTRIBUTE19, AbsenceTypesDEO.ATTRIBUTE20, AbsenceTypesDEO.ATTRIBUTE21, AbsenceTypesDEO.ATTRIBUTE22, AbsenceTypesDEO.ATTRIBUTE23, AbsenceTypesDEO.ATTRIBUTE24, AbsenceTypesDEO.ATTRIBUTE25, AbsenceTypesDEO.ATTRIBUTE26, AbsenceTypesDEO.ATTRIBUTE27, AbsenceTypesDEO.ATTRIBUTE28, AbsenceTypesDEO.ATTRIBUTE29, AbsenceTypesDEO.ATTRIBUTE30, AbsenceTypesDEO.INFORMATION_NUMBER2, AbsenceTypesDEO.INFORMATION_NUMBER1, AbsenceTypesDEO.INFORMATION_NUMBER3, AbsenceTypesDEO.INFORMATION_NUMBER4, AbsenceTypesDEO.INFORMATION_NUMBER5, AbsenceTypesDEO.INFORMATION_NUMBER6, AbsenceTypesDEO.INFORMATION_NUMBER7, AbsenceTypesDEO.INFORMATION_NUMBER8, AbsenceTypesDEO.INFORMATION_NUMBER9, AbsenceTypesDEO.INFORMATION_NUMBER10, AbsenceTypesDEO.INFORMATION_NUMBER11, AbsenceTypesDEO.INFORMATION_NUMBER12, AbsenceTypesDEO.INFORMATION_NUMBER13, AbsenceTypesDEO.INFORMATION_NUMBER14, AbsenceTypesDEO.INFORMATION_NUMBER15, AbsenceTypesDEO.INFORMATION_NUMBER16, AbsenceTypesDEO.INFORMATION_NUMBER17, AbsenceTypesDEO.INFORMATION_NUMBER18, AbsenceTypesDEO.INFORMATION_NUMBER19, AbsenceTypesDEO.INFORMATION_NUMBER20, AbsenceTypesDEO.INFORMATION_DATE1, AbsenceTypesDEO.INFORMATION_DATE2, AbsenceTypesDEO.INFORMATION_DATE3, AbsenceTypesDEO.INFORMATION_DATE4, AbsenceTypesDEO.INFORMATION_DATE5, AbsenceTypesDEO.INFORMATION_DATE6, AbsenceTypesDEO.INFORMATION_DATE7, AbsenceTypesDEO.INFORMATION_DATE8, AbsenceTypesDEO.INFORMATION_DATE9, AbsenceTypesDEO.INFORMATION_DATE10, AbsenceTypesDEO.INFORMATION_DATE11, AbsenceTypesDEO.INFORMATION_DATE12, AbsenceTypesDEO.INFORMATION_DATE13, AbsenceTypesDEO.INFORMATION_DATE14, AbsenceTypesDEO.INFORMATION_DATE15, AbsenceTypesDEO.ATTRIBUTE_NUMBER1, AbsenceTypesDEO.ATTRIBUTE_NUMBER2, AbsenceTypesDEO.ATTRIBUTE_NUMBER3, AbsenceTypesDEO.ATTRIBUTE_NUMBER4, AbsenceTypesDEO.ATTRIBUTE_NUMBER5, AbsenceTypesDEO.ATTRIBUTE_NUMBER6, AbsenceTypesDEO.ATTRIBUTE_NUMBER7, AbsenceTypesDEO.ATTRIBUTE_NUMBER8, AbsenceTypesDEO.ATTRIBUTE_NUMBER9, AbsenceTypesDEO.ATTRIBUTE_NUMBER10, AbsenceTypesDEO.ATTRIBUTE_NUMBER11, AbsenceTypesDEO.ATTRIBUTE_NUMBER12, AbsenceTypesDEO.ATTRIBUTE_NUMBER13, AbsenceTypesDEO.ATTRIBUTE_NUMBER14, AbsenceTypesDEO.ATTRIBUTE_NUMBER15, AbsenceTypesDEO.ATTRIBUTE_NUMBER16, AbsenceTypesDEO.ATTRIBUTE_NUMBER17, AbsenceTypesDEO.ATTRIBUTE_NUMBER18, AbsenceTypesDEO.ATTRIBUTE_NUMBER19, AbsenceTypesDEO.ATTRIBUTE_NUMBER20, AbsenceTypesDEO.ATTRIBUTE_DATE1, AbsenceTypesDEO.ATTRIBUTE_DATE2, AbsenceTypesDEO.ATTRIBUTE_DATE3, AbsenceTypesDEO.ATTRIBUTE_DATE4, AbsenceTypesDEO.ATTRIBUTE_DATE5, AbsenceTypesDEO.ATTRIBUTE_DATE6, AbsenceTypesDEO.ATTRIBUTE_DATE7, AbsenceTypesDEO.ATTRIBUTE_DATE8, AbsenceTypesDEO.ATTRIBUTE_DATE9, AbsenceTypesDEO.ATTRIBUTE_DATE10, AbsenceTypesDEO.ATTRIBUTE_DATE11, AbsenceTypesDEO.ATTRIBUTE_DATE12, AbsenceTypesDEO.ATTRIBUTE_DATE13, AbsenceTypesDEO.ATTRIBUTE_DATE14, AbsenceTypesDEO.ATTRIBUTE_DATE15, AbsenceTypesDEO.ANC_CHAR1, AbsenceTypesDEO.ANC_CHAR2, AbsenceTypesDEO.ANC_CHAR3, AbsenceTypesDEO.ANC_CHAR4, AbsenceTypesDEO.ANC_CHAR5, AbsenceTypesDEO.ANC_NUMBER1, AbsenceTypesDEO.ANC_NUMBER2, AbsenceTypesDEO.ANC_NUMBER3, AbsenceTypesDEO.ANC_NUMBER4, AbsenceTypesDEO.ANC_NUMBER5, AbsenceTypesDEO.ANC_DATE1, AbsenceTypesDEO.ANC_DATE2, AbsenceTypesDEO.ANC_DATE3, AbsenceTypesDEO.ANC_DATE4, AbsenceTypesDEO.ANC_DATE5, AbsenceTypesDEO.MODULE_ID, AbsenceTypesTranslationDEO.SOURCE_LANG, AbsenceTypesDEO.LEG_GROUPING_CD, AbsenceTypesDEO.AGREEMENT_FLAG, AbsenceTypesDEO.OTBI_DLY_BREAKDOWN, AbsenceTypesDEO.BASE_NAME, AbsenceTypesDEO.SGUID SGUID, AbsenceTypesDEO.INCL_OPENEND_ABS_EVAL, AbsenceTypesDEO.EVAL_PERIOD, AbsenceTypesDEO.EVAL_EXTN_PERIOD, AbsenceTypesDEO.ATTACH_TYPE, AbsenceTypesDEO.ATTACH_DURATION_FLAG, AbsenceTypesDEO.ATTACH_ADMIN_FLAG, AbsenceTypesDEO.ATTACH_EMP_FLAG, AbsenceTypesDEO.ATTACH_MGR_FLAG, AbsenceTypesDEO.ATTACH_DURATION_PERIOD, AbsenceTypesDEO.APPROVAL_ROUTING_CD, AbsenceTypesDEO.BASIC_ASSIGNMENT_FLAG, AbsenceTypesDEO.PREVENT_MULTIPLE_ASG_FLAG, AbsenceTypesDEO.DISP_BAL_APRVL_NOTIFIY, AbsenceTypesDEO.BIDDING_ENABLED_FLAG, AbsenceTypesDEO.DISPLAY_SEQUENCE FROM ANC_ABSENCE_TYPES_F AbsenceTypesDEO, ANC_ABSENCE_TYPES_F_TL AbsenceTypesTranslationDEO WHERE AbsenceTypesDEO.ABSENCE_TYPE_ID = AbsenceTypesTranslationDEO.ABSENCE_TYPE_ID AND AbsenceTypesTranslationDEO.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG') AND AbsenceTypesDEO.EFFECTIVE_END_DATE = AbsenceTypesTranslationDEO.EFFECTIVE_END_DATE AND AbsenceTypesDEO.EFFECTIVE_START_DATE = AbsenceTypesTranslationDEO.EFFECTIVE_START_DATE

SQL_Statement

SELECT

AbsenceTypesDEO.ABSENCE_TYPE_ID,

AbsenceTypesDEO.DUR_CALC_BASIS,

AbsenceTypesDEO.ANC_ABSENCE_TYPES_F_ALTCD,

AbsenceTypesDEO.CREATED_BY,

AbsenceTypesDEO.CREATION_DATE,

AbsenceTypesDEO.DURATION_UOM_CD,

AbsenceTypesDEO.EFFECTIVE_END_DATE,

AbsenceTypesDEO.EFFECTIVE_START_DATE,

AbsenceTypesDEO.ENTERPRISE_ID,

AbsenceTypesDEO.LAST_UPDATE_DATE,

AbsenceTypesDEO.LAST_UPDATE_LOGIN,

AbsenceTypesDEO.LAST_UPDATED_BY,

AbsenceTypesDEO.LEGISLATION_CODE,

AbsenceTypesDEO.LEGISLATIVE_DATA_GROUP_ID,

AbsenceTypesDEO.MAX_DURATION,

AbsenceTypesDEO.MAX_DURATION_RULE_CD,

AbsenceTypesDEO.MIN_DURATION,

AbsenceTypesDEO.MIN_DURATION_RULE_CD,

AbsenceTypesDEO.OBJECT_VERSION_NUMBER,

AbsenceTypesDEO.PARTIAL_DAY,

AbsenceTypesDEO.PARTIAL_DAY_FORMULA_ID,

AbsenceTypesDEO.ABSENCE_PATTERN_ID,

AbsenceTypesDEO.MANAGEMENT_TYPE_CD,

AbsenceTypesDEO.STATUS,

AbsenceTypesDEO.MAP_EVENT_TYPE_CD,

AbsenceTypesDEO.EMP_LOCK_IF_CONFIRM_CD,

AbsenceTypesDEO.MGR_LOCK_IF_CONFIRM_CD,

AbsenceTypesDEO.MGR_ALLOW_UPDATES_CD,

AbsenceTypesDEO.EMP_ALLOW_UPDATES_CD,

AbsenceTypesDEO.ADMIN_ALLOW_UPDATES_CD,

AbsenceTypesDEO.LINKAGE_RULE_CD,

AbsenceTypesDEO.LINKAGE_UOM_CD,

AbsenceTypesDEO.LINKAGE_REASON_CD,

AbsenceTypesDEO.LINKAGE_DURATION,

AbsenceTypesTranslationDEO.NAME,

AbsenceTypesTranslationDEO.LANGUAGE,

AbsenceTypesTranslationDEO.DESCRIPTION,

AbsenceTypesDEO.TIMECARD_AVAIL_FLAG,

AbsenceTypesDEO.TIMEKEEPER_AVAIL_FLAG,

AbsenceTypesDEO.SPL_CONDITION,

AbsenceTypesDEO.PATTERN_CD,

AbsenceTypesDEO.BEN_ELIG_PROFILE_ID,

AbsenceTypesDEO.ABSENCE_DURATION_FORMULA_ID,

AbsenceTypesDEO.ABSENCE_VALIDATION_FORMULA_ID,

AbsenceTypesDEO.EXCLUSION_FORMULA_ID,

AbsenceTypesDEO.LINKAGE_START_RULE_CD,

AbsenceTypesDEO.CHILD_EVENT_TYPE_CD,

AbsenceTypesDEO.INFORMATION_CATEGORY,

AbsenceTypesDEO.INFORMATION1,

AbsenceTypesDEO.INFORMATION2,

AbsenceTypesDEO.INFORMATION3,

AbsenceTypesDEO.INFORMATION4,

AbsenceTypesDEO.INFORMATION5,

AbsenceTypesDEO.INFORMATION6,

AbsenceTypesDEO.INFORMATION7,

AbsenceTypesDEO.INFORMATION8,

AbsenceTypesDEO.INFORMATION9,

AbsenceTypesDEO.INFORMATION10,

AbsenceTypesDEO.INFORMATION11,

AbsenceTypesDEO.INFORMATION12,

AbsenceTypesDEO.INFORMATION13,

AbsenceTypesDEO.INFORMATION14,

AbsenceTypesDEO.INFORMATION15,

AbsenceTypesDEO.INFORMATION16,

AbsenceTypesDEO.INFORMATION17,

AbsenceTypesDEO.INFORMATION18,

AbsenceTypesDEO.INFORMATION19,

AbsenceTypesDEO.INFORMATION20,

AbsenceTypesDEO.INFORMATION21,

AbsenceTypesDEO.INFORMATION22,

AbsenceTypesDEO.INFORMATION23,

AbsenceTypesDEO.INFORMATION24,

AbsenceTypesDEO.INFORMATION25,

AbsenceTypesDEO.INFORMATION26,

AbsenceTypesDEO.INFORMATION27,

AbsenceTypesDEO.INFORMATION28,

AbsenceTypesDEO.INFORMATION29,

AbsenceTypesDEO.INFORMATION30,

AbsenceTypesDEO.ATTRIBUTE_CATEGORY,

AbsenceTypesDEO.ATTRIBUTE1,

AbsenceTypesDEO.ATTRIBUTE2,

AbsenceTypesDEO.ATTRIBUTE3,

AbsenceTypesDEO.ATTRIBUTE4,

AbsenceTypesDEO.ATTRIBUTE5,

AbsenceTypesDEO.ATTRIBUTE6,

AbsenceTypesDEO.ATTRIBUTE7,

AbsenceTypesDEO.ATTRIBUTE8,

AbsenceTypesDEO.ATTRIBUTE9,

AbsenceTypesDEO.ATTRIBUTE10,

AbsenceTypesDEO.ATTRIBUTE11,

AbsenceTypesDEO.ATTRIBUTE12,

AbsenceTypesDEO.ATTRIBUTE13,

AbsenceTypesDEO.ATTRIBUTE14,

AbsenceTypesDEO.ATTRIBUTE15,

AbsenceTypesDEO.ATTRIBUTE16,

AbsenceTypesDEO.ATTRIBUTE17,

AbsenceTypesDEO.ATTRIBUTE18,

AbsenceTypesDEO.ATTRIBUTE19,

AbsenceTypesDEO.ATTRIBUTE20,

AbsenceTypesDEO.ATTRIBUTE21,

AbsenceTypesDEO.ATTRIBUTE22,

AbsenceTypesDEO.ATTRIBUTE23,

AbsenceTypesDEO.ATTRIBUTE24,

AbsenceTypesDEO.ATTRIBUTE25,

AbsenceTypesDEO.ATTRIBUTE26,

AbsenceTypesDEO.ATTRIBUTE27,

AbsenceTypesDEO.ATTRIBUTE28,

AbsenceTypesDEO.ATTRIBUTE29,

AbsenceTypesDEO.ATTRIBUTE30,

AbsenceTypesDEO.INFORMATION_NUMBER2,

AbsenceTypesDEO.INFORMATION_NUMBER1,

AbsenceTypesDEO.INFORMATION_NUMBER3,

AbsenceTypesDEO.INFORMATION_NUMBER4,

AbsenceTypesDEO.INFORMATION_NUMBER5,

AbsenceTypesDEO.INFORMATION_NUMBER6,

AbsenceTypesDEO.INFORMATION_NUMBER7,

AbsenceTypesDEO.INFORMATION_NUMBER8,

AbsenceTypesDEO.INFORMATION_NUMBER9,

AbsenceTypesDEO.INFORMATION_NUMBER10,

AbsenceTypesDEO.INFORMATION_NUMBER11,

AbsenceTypesDEO.INFORMATION_NUMBER12,

AbsenceTypesDEO.INFORMATION_NUMBER13,

AbsenceTypesDEO.INFORMATION_NUMBER14,

AbsenceTypesDEO.INFORMATION_NUMBER15,

AbsenceTypesDEO.INFORMATION_NUMBER16,

AbsenceTypesDEO.INFORMATION_NUMBER17,

AbsenceTypesDEO.INFORMATION_NUMBER18,

AbsenceTypesDEO.INFORMATION_NUMBER19,

AbsenceTypesDEO.INFORMATION_NUMBER20,

AbsenceTypesDEO.INFORMATION_DATE1,

AbsenceTypesDEO.INFORMATION_DATE2,

AbsenceTypesDEO.INFORMATION_DATE3,

AbsenceTypesDEO.INFORMATION_DATE4,

AbsenceTypesDEO.INFORMATION_DATE5,

AbsenceTypesDEO.INFORMATION_DATE6,

AbsenceTypesDEO.INFORMATION_DATE7,

AbsenceTypesDEO.INFORMATION_DATE8,

AbsenceTypesDEO.INFORMATION_DATE9,

AbsenceTypesDEO.INFORMATION_DATE10,

AbsenceTypesDEO.INFORMATION_DATE11,

AbsenceTypesDEO.INFORMATION_DATE12,

AbsenceTypesDEO.INFORMATION_DATE13,

AbsenceTypesDEO.INFORMATION_DATE14,

AbsenceTypesDEO.INFORMATION_DATE15,

AbsenceTypesDEO.ATTRIBUTE_NUMBER1,

AbsenceTypesDEO.ATTRIBUTE_NUMBER2,

AbsenceTypesDEO.ATTRIBUTE_NUMBER3,

AbsenceTypesDEO.ATTRIBUTE_NUMBER4,

AbsenceTypesDEO.ATTRIBUTE_NUMBER5,

AbsenceTypesDEO.ATTRIBUTE_NUMBER6,

AbsenceTypesDEO.ATTRIBUTE_NUMBER7,

AbsenceTypesDEO.ATTRIBUTE_NUMBER8,

AbsenceTypesDEO.ATTRIBUTE_NUMBER9,

AbsenceTypesDEO.ATTRIBUTE_NUMBER10,

AbsenceTypesDEO.ATTRIBUTE_NUMBER11,

AbsenceTypesDEO.ATTRIBUTE_NUMBER12,

AbsenceTypesDEO.ATTRIBUTE_NUMBER13,

AbsenceTypesDEO.ATTRIBUTE_NUMBER14,

AbsenceTypesDEO.ATTRIBUTE_NUMBER15,

AbsenceTypesDEO.ATTRIBUTE_NUMBER16,

AbsenceTypesDEO.ATTRIBUTE_NUMBER17,

AbsenceTypesDEO.ATTRIBUTE_NUMBER18,

AbsenceTypesDEO.ATTRIBUTE_NUMBER19,

AbsenceTypesDEO.ATTRIBUTE_NUMBER20,

AbsenceTypesDEO.ATTRIBUTE_DATE1,

AbsenceTypesDEO.ATTRIBUTE_DATE2,

AbsenceTypesDEO.ATTRIBUTE_DATE3,

AbsenceTypesDEO.ATTRIBUTE_DATE4,

AbsenceTypesDEO.ATTRIBUTE_DATE5,

AbsenceTypesDEO.ATTRIBUTE_DATE6,

AbsenceTypesDEO.ATTRIBUTE_DATE7,

AbsenceTypesDEO.ATTRIBUTE_DATE8,

AbsenceTypesDEO.ATTRIBUTE_DATE9,

AbsenceTypesDEO.ATTRIBUTE_DATE10,

AbsenceTypesDEO.ATTRIBUTE_DATE11,

AbsenceTypesDEO.ATTRIBUTE_DATE12,

AbsenceTypesDEO.ATTRIBUTE_DATE13,

AbsenceTypesDEO.ATTRIBUTE_DATE14,

AbsenceTypesDEO.ATTRIBUTE_DATE15,

AbsenceTypesDEO.ANC_CHAR1,

AbsenceTypesDEO.ANC_CHAR2,

AbsenceTypesDEO.ANC_CHAR3,

AbsenceTypesDEO.ANC_CHAR4,

AbsenceTypesDEO.ANC_CHAR5,

AbsenceTypesDEO.ANC_NUMBER1,

AbsenceTypesDEO.ANC_NUMBER2,

AbsenceTypesDEO.ANC_NUMBER3,

AbsenceTypesDEO.ANC_NUMBER4,

AbsenceTypesDEO.ANC_NUMBER5,

AbsenceTypesDEO.ANC_DATE1,

AbsenceTypesDEO.ANC_DATE2,

AbsenceTypesDEO.ANC_DATE3,

AbsenceTypesDEO.ANC_DATE4,

AbsenceTypesDEO.ANC_DATE5,

AbsenceTypesDEO.MODULE_ID,

AbsenceTypesTranslationDEO.SOURCE_LANG,

AbsenceTypesDEO.LEG_GROUPING_CD,

AbsenceTypesDEO.AGREEMENT_FLAG,

AbsenceTypesDEO.OTBI_DLY_BREAKDOWN,

AbsenceTypesDEO.BASE_NAME,

AbsenceTypesDEO.SGUID SGUID,

AbsenceTypesDEO.INCL_OPENEND_ABS_EVAL,

AbsenceTypesDEO.EVAL_PERIOD,

AbsenceTypesDEO.EVAL_EXTN_PERIOD,

AbsenceTypesDEO.ATTACH_TYPE,

AbsenceTypesDEO.ATTACH_DURATION_FLAG,

AbsenceTypesDEO.ATTACH_ADMIN_FLAG,

AbsenceTypesDEO.ATTACH_EMP_FLAG,

AbsenceTypesDEO.ATTACH_MGR_FLAG,

AbsenceTypesDEO.ATTACH_DURATION_PERIOD,

AbsenceTypesDEO.APPROVAL_ROUTING_CD,

AbsenceTypesDEO.BASIC_ASSIGNMENT_FLAG,

AbsenceTypesDEO.PREVENT_MULTIPLE_ASG_FLAG,

AbsenceTypesDEO.DISP_BAL_APRVL_NOTIFIY,

AbsenceTypesDEO.BIDDING_ENABLED_FLAG,

AbsenceTypesDEO.DISPLAY_SEQUENCE

FROM

ANC_ABSENCE_TYPES_F AbsenceTypesDEO,

ANC_ABSENCE_TYPES_F_TL AbsenceTypesTranslationDEO

WHERE

AbsenceTypesDEO.ABSENCE_TYPE_ID = AbsenceTypesTranslationDEO.ABSENCE_TYPE_ID AND AbsenceTypesTranslationDEO.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG') AND AbsenceTypesDEO.EFFECTIVE_END_DATE = AbsenceTypesTranslationDEO.EFFECTIVE_END_DATE AND AbsenceTypesDEO.EFFECTIVE_START_DATE = AbsenceTypesTranslationDEO.EFFECTIVE_START_DATE