ANC_ABSENCE_PLANS

Details

Schema: FUSION
Object owner: ANC
Object type: VIEW

Columns

Name
ABSENCE_DURATION_DEFN_ID ABSENCE_PLAN_ID ACC_DEFINITION_TYPE ACC_FORMULA_ID CARRY_OVER_FLAT_AMT CARRY_OVER_FORMULA_ID CARRY_OVER_PRORATE_FORMULA_ID CEIL_LIMIT_FLAT_AMT CEIL_LIMIT_FORMULA_ID CEIL_LMT_PRORATE_FORMULA_ID EFFECTIVE_END_DATE EFFECTIVE_START_DATE ENROLLMENT_END_FORMULA_ID ENROLLMENT_START_FORMULA_ID ENTITLEMENT_END_FORMULA_ID ENTL_DEFINITION_TYPE ENTL_FORMULA_ID ENTL_METHOD_CD LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID OVERLAP_CD PAY_RATE_FACTOR PLAN_MGMT_CD PLAN_PERIOD_ID PLAN_PERIOD_TYPE PLAN_STATUS PLAN_UOM PROCESSING_LEVEL_CD PRORATION_FORMULA_ID VESTING_PERIOD_FORMULA_ID DESCRIPTION LANGUAGE NAME SOURCE_LANG PAY_ADVANCES_FLAG ENROLL_TERMINATE_ENTL_FLAG ENROLL_POSITIVE_BALANCE_FLAG ENROLL_NEGATIVE_BALANCE_FLAG EMP_ENRL_TERMINATE_ENTL_FLAG EMP_ENRL_POSITIVE_BALANCE_FLAG EMP_ENRL_NEGATIVE_BALANCE_FLAG ENTERPRISE_ID PERIOD_UOM OBJECT_VERSION_NUMBER ACCRUAL_VESTING_CD ROLL_PERIOD_DURATION ROLL_FORWARD_START_RULE ROLL_FORWARD_START_FORMULA_ID ROLL_BACKWARD_END_RULE ROLL_BACKWARD_END_FORMULA_ID PRORATION_RULE ENTITLEMENT_END_RULE ENROLLMENT_START_RULE ENROLLMENT_END_RULE EXPIRATION_TERM_CD EXPIRATION_LIMIT EXPIRATION_UOM_CD EXPIRATION_ACTION_CD MGR_EXPIRATION_UPDATE ADMIN_EXPIRATION_UPDATE COMP_MNUL_ADJRSN COMP_EXP_ADJRSN CEIL_LIMIT_RULE CEIL_LIMIT_PRORATE_RULE CARRY_OVER_RULE CARRY_OVER_PRORATE_RULE CARRY_OVER_EXPIRED_UOM CARRY_OVER_EXPIRED_UNITS CARRY_OVER_EXPIRED_FLAG CALENDAR_START_MONTH CALENDAR_START_DAY ANNIVERSARY_EVENT_RULE ANNIVERSARY_EVENT_FORMULA_ID ACC_PERIOD_WFM_CALEDAR_ID ACC_PERIOD_PAYROLL_FREQ_ID ACC_PERIOD_FREQUENCY WAIT_PERIOD_DUR_UNITS WAIT_PERIOD_DUR_UOM ACC_NEGATIVE_BAL_FLAG ACC_NEGATIVE_BAL_LIMIT ACC_NEGATIVE_BAL_UOM ANC_ABSENCE_PLANS_F_ALTCD STATUTORY_FLAG ACCRUAL_MODE OTHER_ADJUSTMENT_FLAG OTHER_REASONS PAYOUT_RATE_FORMULA_ID PAYOUT_RATE_RULE PAYROLL_IMPACT_FLAG PAYROLL_MAPPING_ID PLAN_ACTIVATION_FLAG PREV_EMP_USAGE_FLAG PREV_EMP_ENTL_FLAG PLAN_USE_FORMULA_ID PLAN_USE_RATE_RULE CASH_OUT_FLAG CASHOUT_RATE_FORMULA_ID CASHOUT_RATE_RULE BALANCE_TRANSFER_FLAG PLAN_USE_RATE_ID CASHOUT_RATE_ID LIABILITY_RATE_FORMULA_ID LIABILITY_RATE_ID LIABILITY_RATE_RULE PAYOUT_RATE_ID ABSENCE_DURATION_FORMULA_ID EVAL_ENTITLEMENT_FLAG DISABLE_ENT_OVERRIDE_FLAG LEG_GROUPING_CD BASE_NAME SGUID MGR_MANUAL_ADJUSTMENT ADMIN_MANUAL_ADJUSTMENT ACC_LMT_RULE ACC_LMT_FLAT_AMT ACC_LIMIT_FORMULA_ID ACC_LIMIT_PRORATE_RULE ACC_LMT_PRORATE_FORMULA_ID RE_ENRL_BAL_LMT TIME_FRAME_LMT TIME_FRAME_UOM ACC_EMP_BAL_DISPLAY ACC_MGR_BAL_DISPLAY RE_INSTATEMENT_FLAG BEN_IMPACT_FLAG PENDING_DISBURSE_FLAG ELECTION_DATE_RULE TRANSFR_POSITIVE_BALANCE_FLAG TRANSFR_LMT_RULE TRANSFR_LMT_FLAT_AMT TRANSFR_LMT_FORMULA_ID TRANSFR_LMT_PRORATE_RULE TRANSFR_LMT_PRORATE_FORMULA_ID TRANSFR_PLAN_CATEGORY TRANSFR_TARGET_FORMULA_ID ROLLOVR_LMT_RULE ROLLOVR_LMT_FLAT_AMT ROLLOVR_LMT_FORMULA_ID ROLLOVR_LMT_PRORATE_RULE ROLLOVR_LMT_PRORATE_FORMULA_ID ROLLOVR_TARGET_PLAN ROLLOVR_PLAN_CONVERSION_RATE YEAR_END_BALANCE_DISBURSE_FLAG ELECT_DISB_PAY_RATE_FACTOR YREND_DISB_PAY_RATE_FACTOR ELECT_DISB_VALID_FORMULA_ID YREND_DISB_VALID_FORMULA_ID COMP_MGR_MANUAL_ADJ ALLOW_CASHOUT_COVR_ADMIN ALLOW_CASHOUT_COVR_MGR ALLOW_CASHOUT_COVR_EMP PARTIAL_ACCRUAL_PRORATION_RULE PARTIAL_ACCRUAL_FORMULA_ID ROUNDING_RULE ROUNDING_PRECISION ACCRUAL_POSTING_CD GT_ENROLL_POSITIVE_BAL_FLAG GT_ENROLL_NEGATIVE_BAL_FLAG GT_TRANSFR_POSTIVE_BAL_FLAG GT_ROLLOVER_POSTIVE_BAL_FLAG GT_TRANSFR_LMT_RULE GT_TRANSFR_LMT_FLAT_AMT GT_TRANSFR_LMT_FORMULA_ID GT_TRANSFR_LMT_PRORATE_RULE GT_TRFR_LMT_PRORATE_FORMULA_ID GT_TRANSFR_PLAN_CATEGORY GT_TRFR_TARGET_FORMULA_ID GT_TRANSFR_TO_RULES GT_ROLLOVER_TARGET_PLAN GT_ROLLOVER_LMT_RULE GT_ROLLOVER_LMT_FLAT_AMT GT_ROLLOVER_LMT_FORMULA_ID GT_ROLLOVER_PLAN_CONV_RATE GT_ROLL_PRORATE_LMT_RULE GT_ROLL_PRORATE_LMT_FRMLA_ID GT_ROLLOVER_TARGET_PLAN_ID ELIG_ROLLOVER_POSTIVE_BAL_FLAG ELIG_ROLLOVER_TARGET_PLAN ELIG_ROLLOVER_LMT_RULE ELIG_ROLLOVER_LMT_FLAT_AMT ELIG_ROLLOVER_LMT_FORMULA_ID ELIG_ROLLOVER_PLAN_CONV_RATE ELIG_ROLLOVER_PLAN_CONVR_RATE ELIG_ROLL_PRORATE_LMT_RULE ELIG_ROLL_PRORATE_LMT_FRMLA_ID ELIG_ROLLOVER_TARGET_PLAN_ID ELIG_RETAIN_CARRYOVER_BAL_FLAG GT_RETAIN_CARRYOVER_BAL_FLAG DONATION_TYPE RTN_PSTV_BAL_TO_POOL_FLAG RATE_DATE_RULE ELIG_FORFT_BALANCE_FLAG GT_FORFT_BALANCE_FLAG TERM_FORFT_BALANCE_FLAG

Name

ABSENCE_DURATION_DEFN_ID

ABSENCE_PLAN_ID

ACC_DEFINITION_TYPE

ACC_FORMULA_ID

CARRY_OVER_FLAT_AMT

CARRY_OVER_FORMULA_ID

CARRY_OVER_PRORATE_FORMULA_ID

CEIL_LIMIT_FLAT_AMT

CEIL_LIMIT_FORMULA_ID

CEIL_LMT_PRORATE_FORMULA_ID

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

ENROLLMENT_END_FORMULA_ID

ENROLLMENT_START_FORMULA_ID

ENTITLEMENT_END_FORMULA_ID

ENTL_DEFINITION_TYPE

ENTL_FORMULA_ID

ENTL_METHOD_CD

LEGISLATION_CODE

LEGISLATIVE_DATA_GROUP_ID

OVERLAP_CD

PAY_RATE_FACTOR

PLAN_MGMT_CD

PLAN_PERIOD_ID

PLAN_PERIOD_TYPE

PLAN_STATUS

PLAN_UOM

PROCESSING_LEVEL_CD

PRORATION_FORMULA_ID

VESTING_PERIOD_FORMULA_ID

DESCRIPTION

LANGUAGE

NAME

SOURCE_LANG

PAY_ADVANCES_FLAG

ENROLL_TERMINATE_ENTL_FLAG

ENROLL_POSITIVE_BALANCE_FLAG

ENROLL_NEGATIVE_BALANCE_FLAG

EMP_ENRL_TERMINATE_ENTL_FLAG

EMP_ENRL_POSITIVE_BALANCE_FLAG

EMP_ENRL_NEGATIVE_BALANCE_FLAG

ENTERPRISE_ID

PERIOD_UOM

OBJECT_VERSION_NUMBER

ACCRUAL_VESTING_CD

ROLL_PERIOD_DURATION

ROLL_FORWARD_START_RULE

ROLL_FORWARD_START_FORMULA_ID

ROLL_BACKWARD_END_RULE

ROLL_BACKWARD_END_FORMULA_ID

PRORATION_RULE

ENTITLEMENT_END_RULE

ENROLLMENT_START_RULE

ENROLLMENT_END_RULE

EXPIRATION_TERM_CD

EXPIRATION_LIMIT

EXPIRATION_UOM_CD

EXPIRATION_ACTION_CD

MGR_EXPIRATION_UPDATE

ADMIN_EXPIRATION_UPDATE

COMP_MNUL_ADJRSN

COMP_EXP_ADJRSN

CEIL_LIMIT_RULE

CEIL_LIMIT_PRORATE_RULE

CARRY_OVER_RULE

CARRY_OVER_PRORATE_RULE

CARRY_OVER_EXPIRED_UOM

CARRY_OVER_EXPIRED_UNITS

CARRY_OVER_EXPIRED_FLAG

CALENDAR_START_MONTH

CALENDAR_START_DAY

ANNIVERSARY_EVENT_RULE

ANNIVERSARY_EVENT_FORMULA_ID

ACC_PERIOD_WFM_CALEDAR_ID

ACC_PERIOD_PAYROLL_FREQ_ID

ACC_PERIOD_FREQUENCY

WAIT_PERIOD_DUR_UNITS

WAIT_PERIOD_DUR_UOM

ACC_NEGATIVE_BAL_FLAG

ACC_NEGATIVE_BAL_LIMIT

ACC_NEGATIVE_BAL_UOM

ANC_ABSENCE_PLANS_F_ALTCD

STATUTORY_FLAG

ACCRUAL_MODE

OTHER_ADJUSTMENT_FLAG

OTHER_REASONS

PAYOUT_RATE_FORMULA_ID

PAYOUT_RATE_RULE

PAYROLL_IMPACT_FLAG

PAYROLL_MAPPING_ID

PLAN_ACTIVATION_FLAG

PREV_EMP_USAGE_FLAG

PREV_EMP_ENTL_FLAG

PLAN_USE_FORMULA_ID

PLAN_USE_RATE_RULE

CASH_OUT_FLAG

CASHOUT_RATE_FORMULA_ID

CASHOUT_RATE_RULE

BALANCE_TRANSFER_FLAG

PLAN_USE_RATE_ID

CASHOUT_RATE_ID

LIABILITY_RATE_FORMULA_ID

LIABILITY_RATE_ID

LIABILITY_RATE_RULE

PAYOUT_RATE_ID

ABSENCE_DURATION_FORMULA_ID

EVAL_ENTITLEMENT_FLAG

DISABLE_ENT_OVERRIDE_FLAG

LEG_GROUPING_CD

BASE_NAME

SGUID

MGR_MANUAL_ADJUSTMENT

ADMIN_MANUAL_ADJUSTMENT

ACC_LMT_RULE

ACC_LMT_FLAT_AMT

ACC_LIMIT_FORMULA_ID

ACC_LIMIT_PRORATE_RULE

ACC_LMT_PRORATE_FORMULA_ID

RE_ENRL_BAL_LMT

TIME_FRAME_LMT

TIME_FRAME_UOM

ACC_EMP_BAL_DISPLAY

ACC_MGR_BAL_DISPLAY

RE_INSTATEMENT_FLAG

BEN_IMPACT_FLAG

PENDING_DISBURSE_FLAG

ELECTION_DATE_RULE

TRANSFR_POSITIVE_BALANCE_FLAG

TRANSFR_LMT_RULE

TRANSFR_LMT_FLAT_AMT

TRANSFR_LMT_FORMULA_ID

TRANSFR_LMT_PRORATE_RULE

TRANSFR_LMT_PRORATE_FORMULA_ID

TRANSFR_PLAN_CATEGORY

TRANSFR_TARGET_FORMULA_ID

ROLLOVR_LMT_RULE

ROLLOVR_LMT_FLAT_AMT

ROLLOVR_LMT_FORMULA_ID

ROLLOVR_LMT_PRORATE_RULE

ROLLOVR_LMT_PRORATE_FORMULA_ID

ROLLOVR_TARGET_PLAN

ROLLOVR_PLAN_CONVERSION_RATE

YEAR_END_BALANCE_DISBURSE_FLAG

ELECT_DISB_PAY_RATE_FACTOR

YREND_DISB_PAY_RATE_FACTOR

ELECT_DISB_VALID_FORMULA_ID

YREND_DISB_VALID_FORMULA_ID

COMP_MGR_MANUAL_ADJ

ALLOW_CASHOUT_COVR_ADMIN

ALLOW_CASHOUT_COVR_MGR

ALLOW_CASHOUT_COVR_EMP

PARTIAL_ACCRUAL_PRORATION_RULE

PARTIAL_ACCRUAL_FORMULA_ID

ROUNDING_RULE

ROUNDING_PRECISION

ACCRUAL_POSTING_CD

GT_ENROLL_POSITIVE_BAL_FLAG

GT_ENROLL_NEGATIVE_BAL_FLAG

GT_TRANSFR_POSTIVE_BAL_FLAG

GT_ROLLOVER_POSTIVE_BAL_FLAG

GT_TRANSFR_LMT_RULE

GT_TRANSFR_LMT_FLAT_AMT

GT_TRANSFR_LMT_FORMULA_ID

GT_TRANSFR_LMT_PRORATE_RULE

GT_TRFR_LMT_PRORATE_FORMULA_ID

GT_TRANSFR_PLAN_CATEGORY

GT_TRFR_TARGET_FORMULA_ID

GT_TRANSFR_TO_RULES

GT_ROLLOVER_TARGET_PLAN

GT_ROLLOVER_LMT_RULE

GT_ROLLOVER_LMT_FLAT_AMT

GT_ROLLOVER_LMT_FORMULA_ID

GT_ROLLOVER_PLAN_CONV_RATE

GT_ROLL_PRORATE_LMT_RULE

GT_ROLL_PRORATE_LMT_FRMLA_ID

GT_ROLLOVER_TARGET_PLAN_ID

ELIG_ROLLOVER_POSTIVE_BAL_FLAG

ELIG_ROLLOVER_TARGET_PLAN

ELIG_ROLLOVER_LMT_RULE

ELIG_ROLLOVER_LMT_FLAT_AMT

ELIG_ROLLOVER_LMT_FORMULA_ID

ELIG_ROLLOVER_PLAN_CONV_RATE

ELIG_ROLLOVER_PLAN_CONVR_RATE

ELIG_ROLL_PRORATE_LMT_RULE

ELIG_ROLL_PRORATE_LMT_FRMLA_ID

ELIG_ROLLOVER_TARGET_PLAN_ID

ELIG_RETAIN_CARRYOVER_BAL_FLAG

GT_RETAIN_CARRYOVER_BAL_FLAG

DONATION_TYPE

RTN_PSTV_BAL_TO_POOL_FLAG

RATE_DATE_RULE

ELIG_FORFT_BALANCE_FLAG

GT_FORFT_BALANCE_FLAG

TERM_FORFT_BALANCE_FLAG

Query

SQL_Statement
SELECT AbsencePlanDEO.ABSENCE_DURATION_DEFN_ID, AbsencePlanDEO.ABSENCE_PLAN_ID, AbsencePlanDEO.ACC_DEFINITION_TYPE, AbsencePlanDEO.ACC_FORMULA_ID, AbsencePlanDEO.CARRY_OVER_FLAT_AMT, AbsencePlanDEO.CARRY_OVER_FORMULA_ID, AbsencePlanDEO.CARRY_OVER_PRORATE_FORMULA_ID, AbsencePlanDEO.CEIL_LIMIT_FLAT_AMT, AbsencePlanDEO.CEIL_LIMIT_FORMULA_ID, AbsencePlanDEO.CEIL_LMT_PRORATE_FORMULA_ID, AbsencePlanDEO.EFFECTIVE_END_DATE, AbsencePlanDEO.EFFECTIVE_START_DATE, AbsencePlanDEO.ENROLLMENT_END_FORMULA_ID, AbsencePlanDEO.ENROLLMENT_START_FORMULA_ID, AbsencePlanDEO.ENTITLEMENT_END_FORMULA_ID, AbsencePlanDEO.ENTL_DEFINITION_TYPE, AbsencePlanDEO.ENTL_FORMULA_ID, AbsencePlanDEO.ENTL_METHOD_CD, AbsencePlanDEO.LEGISLATION_CODE, AbsencePlanDEO.LEGISLATIVE_DATA_GROUP_ID, AbsencePlanDEO.OVERLAP_CD, AbsencePlanDEO.PAY_RATE_FACTOR, AbsencePlanDEO.PLAN_MGMT_CD, AbsencePlanDEO.PLAN_PERIOD_ID, AbsencePlanDEO.PLAN_PERIOD_TYPE, AbsencePlanDEO.PLAN_STATUS, AbsencePlanDEO.PLAN_UOM, AbsencePlanDEO.PROCESSING_LEVEL_CD, AbsencePlanDEO.PRORATION_FORMULA_ID, AbsencePlanDEO.VESTING_PERIOD_FORMULA_ID, AbsencePlanTranslationEO.DESCRIPTION, AbsencePlanTranslationEO.LANGUAGE, AbsencePlanTranslationEO.NAME, AbsencePlanTranslationEO.SOURCE_LANG, AbsencePlanDEO.PAY_ADVANCES_FLAG, AbsencePlanDEO.ENROLL_TERMINATE_ENTL_FLAG, AbsencePlanDEO.ENROLL_POSITIVE_BALANCE_FLAG, AbsencePlanDEO.ENROLL_NEGATIVE_BALANCE_FLAG, AbsencePlanDEO.EMP_ENRL_TERMINATE_ENTL_FLAG, AbsencePlanDEO.EMP_ENRL_POSITIVE_BALANCE_FLAG, AbsencePlanDEO.EMP_ENRL_NEGATIVE_BALANCE_FLAG, AbsencePlanDEO.ENTERPRISE_ID, AbsencePlanDEO.PERIOD_UOM, AbsencePlanDEO.OBJECT_VERSION_NUMBER, AbsencePlanDEO.ACCRUAL_VESTING_CD, AbsencePlanDEO.ROLL_PERIOD_DURATION, AbsencePlanDEO.ROLL_FORWARD_START_RULE, AbsencePlanDEO.ROLL_FORWARD_START_FORMULA_ID, AbsencePlanDEO.ROLL_BACKWARD_END_RULE, AbsencePlanDEO.ROLL_BACKWARD_END_FORMULA_ID, AbsencePlanDEO.PRORATION_RULE, AbsencePlanDEO.ENTITLEMENT_END_RULE, AbsencePlanDEO.ENROLLMENT_START_RULE, AbsencePlanDEO.ENROLLMENT_END_RULE, AbsencePlanDEO.EXPIRATION_TERM_CD, AbsencePlanDEO.EXPIRATION_LIMIT, AbsencePlanDEO.EXPIRATION_UOM_CD, AbsencePlanDEO.EXPIRATION_ACTION_CD, AbsencePlanDEO.MGR_EXPIRATION_UPDATE, AbsencePlanDEO.ADMIN_EXPIRATION_UPDATE, AbsencePlanDEO.COMP_MNUL_ADJRSN, AbsencePlanDEO.COMP_EXP_ADJRSN, AbsencePlanDEO.CEIL_LIMIT_RULE, AbsencePlanDEO.CEIL_LIMIT_PRORATE_RULE, AbsencePlanDEO.CARRY_OVER_RULE, AbsencePlanDEO.CARRY_OVER_PRORATE_RULE, AbsencePlanDEO.CARRY_OVER_EXPIRED_UOM, AbsencePlanDEO.CARRY_OVER_EXPIRED_UNITS, AbsencePlanDEO.CARRY_OVER_EXPIRED_FLAG, AbsencePlanDEO.CALENDAR_START_MONTH, AbsencePlanDEO.CALENDAR_START_DAY, AbsencePlanDEO.ANNIVERSARY_EVENT_RULE, AbsencePlanDEO.ANNIVERSARY_EVENT_FORMULA_ID, AbsencePlanDEO.ACC_PERIOD_WFM_CALEDAR_ID, AbsencePlanDEO.ACC_PERIOD_PAYROLL_FREQ_ID, AbsencePlanDEO.ACC_PERIOD_FREQUENCY, AbsencePlanDEO.WAIT_PERIOD_DUR_UNITS, AbsencePlanDEO.WAIT_PERIOD_DUR_UOM, AbsencePlanDEO.ACC_NEGATIVE_BAL_FLAG, AbsencePlanDEO.ACC_NEGATIVE_BAL_LIMIT, AbsencePlanDEO.ACC_NEGATIVE_BAL_UOM, AbsencePlanDEO.ANC_ABSENCE_PLANS_F_ALTCD, AbsencePlanDEO.STATUTORY_FLAG, AbsencePlanDEO.ACCRUAL_MODE, AbsencePlanDEO.OTHER_ADJUSTMENT_FLAG, AbsencePlanDEO.OTHER_REASONS, AbsencePlanDEO.PAYOUT_RATE_FORMULA_ID, AbsencePlanDEO.PAYOUT_RATE_RULE, AbsencePlanDEO.PAYROLL_IMPACT_FLAG, AbsencePlanDEO.PAYROLL_MAPPING_ID, AbsencePlanDEO.PLAN_ACTIVATION_FLAG, AbsencePlanDEO.PREV_EMP_USAGE_FLAG, AbsencePlanDEO.PREV_EMP_ENTL_FLAG, AbsencePlanDEO.PLAN_USE_FORMULA_ID, AbsencePlanDEO.PLAN_USE_RATE_RULE, AbsencePlanDEO.CASH_OUT_FLAG, AbsencePlanDEO.CASHOUT_RATE_FORMULA_ID, AbsencePlanDEO.CASHOUT_RATE_RULE, AbsencePlanDEO.BALANCE_TRANSFER_FLAG, AbsencePlanDEO.PLAN_USE_RATE_ID, AbsencePlanDEO.CASHOUT_RATE_ID, AbsencePlanDEO.LIABILITY_RATE_FORMULA_ID, AbsencePlanDEO.LIABILITY_RATE_ID, AbsencePlanDEO.LIABILITY_RATE_RULE, AbsencePlanDEO.PAYOUT_RATE_ID, AbsencePlanDEO.ABSENCE_DURATION_FORMULA_ID, AbsencePlanDEO.EVAL_ENTITLEMENT_FLAG, AbsencePlanDEO.DISABLE_ENT_OVERRIDE_FLAG, AbsencePlanDEO.LEG_GROUPING_CD, AbsencePlanDEO.BASE_NAME, AbsencePlanDEO.SGUID SGUID, AbsencePlanDEO.MGR_MANUAL_ADJUSTMENT, AbsencePlanDEO.ADMIN_MANUAL_ADJUSTMENT, AbsencePlanDEO.ACC_LMT_RULE, AbsencePlanDEO.ACC_LMT_FLAT_AMT, AbsencePlanDEO.ACC_LIMIT_FORMULA_ID, AbsencePlanDEO.ACC_LIMIT_PRORATE_RULE, AbsencePlanDEO.ACC_LMT_PRORATE_FORMULA_ID, AbsencePlanDEO.RE_ENRL_BAL_LMT, AbsencePlanDEO.TIME_FRAME_LMT, AbsencePlanDEO.TIME_FRAME_UOM, AbsencePlanDEO.ACC_EMP_BAL_DISPLAY, AbsencePlanDEO.ACC_MGR_BAL_DISPLAY, AbsencePlanDEO.RE_INSTATEMENT_FLAG, AbsencePlanDEO.BEN_IMPACT_FLAG, AbsencePlanDEO.PENDING_DISBURSE_FLAG, AbsencePlanDEO.ELECTION_DATE_RULE, AbsencePlanDEO.TRANSFR_POSITIVE_BALANCE_FLAG, AbsencePlanDEO.TRANSFR_LMT_RULE, AbsencePlanDEO.TRANSFR_LMT_FLAT_AMT, AbsencePlanDEO.TRANSFR_LMT_FORMULA_ID, AbsencePlanDEO.TRANSFR_LMT_PRORATE_RULE, AbsencePlanDEO.TRANSFR_LMT_PRORATE_FORMULA_ID, AbsencePlanDEO.TRANSFR_PLAN_CATEGORY, AbsencePlanDEO.TRANSFR_TARGET_FORMULA_ID, AbsencePlanDEO.ROLLOVR_LMT_RULE, AbsencePlanDEO.ROLLOVR_LMT_FLAT_AMT, AbsencePlanDEO.ROLLOVR_LMT_FORMULA_ID, AbsencePlanDEO.ROLLOVR_LMT_PRORATE_RULE, AbsencePlanDEO.ROLLOVR_LMT_PRORATE_FORMULA_ID, AbsencePlanDEO.ROLLOVR_TARGET_PLAN, AbsencePlanDEO.ROLLOVR_PLAN_CONVERSION_RATE, AbsencePlanDEO.YEAR_END_BALANCE_DISBURSE_FLAG, AbsencePlanDEO.ELECT_DISB_PAY_RATE_FACTOR, AbsencePlanDEO.YREND_DISB_PAY_RATE_FACTOR, AbsencePlanDEO.ELECT_DISB_VALID_FORMULA_ID, AbsencePlanDEO.YREND_DISB_VALID_FORMULA_ID, AbsencePlanDEO.COMP_MGR_MANUAL_ADJ, AbsencePlanDEO.ALLOW_CASHOUT_COVR_ADMIN, AbsencePlanDEO.ALLOW_CASHOUT_COVR_MGR, AbsencePlanDEO.ALLOW_CASHOUT_COVR_EMP, AbsencePlanDEO.PARTIAL_ACCRUAL_PRORATION_RULE, AbsencePlanDEO.PARTIAL_ACCRUAL_FORMULA_ID, AbsencePlanDEO.ROUNDING_RULE, AbsencePlanDEO.ROUNDING_PRECISION, AbsencePlanDEO.ACCRUAL_POSTING_CD, AbsencePlanDEO.GT_ENROLL_POSITIVE_BAL_FLAG, AbsencePlanDEO.GT_ENROLL_NEGATIVE_BAL_FLAG, AbsencePlanDEO.GT_TRANSFR_POSTIVE_BAL_FLAG, AbsencePlanDEO.GT_ROLLOVER_POSTIVE_BAL_FLAG, AbsencePlanDEO.GT_TRANSFR_LMT_RULE, AbsencePlanDEO.GT_TRANSFR_LMT_FLAT_AMT, AbsencePlanDEO.GT_TRANSFR_LMT_FORMULA_ID, AbsencePlanDEO.GT_TRANSFR_LMT_PRORATE_RULE, AbsencePlanDEO.GT_TRFR_LMT_PRORATE_FORMULA_ID, AbsencePlanDEO.GT_TRANSFR_PLAN_CATEGORY, AbsencePlanDEO.GT_TRFR_TARGET_FORMULA_ID, AbsencePlanDEO.GT_TRANSFR_TO_RULES, AbsencePlanDEO.GT_ROLLOVER_TARGET_PLAN, AbsencePlanDEO.GT_ROLLOVER_LMT_RULE, AbsencePlanDEO.GT_ROLLOVER_LMT_FLAT_AMT, AbsencePlanDEO.GT_ROLLOVER_LMT_FORMULA_ID, AbsencePlanDEO.GT_ROLLOVER_PLAN_CONV_RATE, AbsencePlanDEO.GT_ROLL_PRORATE_LMT_RULE, AbsencePlanDEO.GT_ROLL_PRORATE_LMT_FRMLA_ID, AbsencePlanDEO.GT_ROLLOVER_TARGET_PLAN_ID, AbsencePlanDEO.ELIG_ROLLOVER_POSTIVE_BAL_FLAG, AbsencePlanDEO.ELIG_ROLLOVER_TARGET_PLAN, AbsencePlanDEO.ELIG_ROLLOVER_LMT_RULE, AbsencePlanDEO.ELIG_ROLLOVER_LMT_FLAT_AMT, AbsencePlanDEO.ELIG_ROLLOVER_LMT_FORMULA_ID, AbsencePlanDEO.ELIG_ROLLOVER_PLAN_CONV_RATE, AbsencePlanDEO.ELIG_ROLLOVER_PLAN_CONVR_RATE, AbsencePlanDEO.ELIG_ROLL_PRORATE_LMT_RULE, AbsencePlanDEO.ELIG_ROLL_PRORATE_LMT_FRMLA_ID, AbsencePlanDEO.ELIG_ROLLOVER_TARGET_PLAN_ID, AbsencePlanDEO.ELIG_RETAIN_CARRYOVER_BAL_FLAG, AbsencePlanDEO.GT_RETAIN_CARRYOVER_BAL_FLAG, AbsencePlanDEO.DONATION_TYPE, AbsencePlanDEO.RTN_PSTV_BAL_TO_POOL_FLAG, AbsencePlanDEO.RATE_DATE_RULE, AbsencePlanDEO.ELIG_FORFT_BALANCE_FLAG, AbsencePlanDEO.GT_FORFT_BALANCE_FLAG, AbsencePlanDEO.TERM_FORFT_BALANCE_FLAG FROM ANC_ABSENCE_PLANS_F AbsencePlanDEO, ANC_ABSENCE_PLANS_F_TL AbsencePlanTranslationEO WHERE AbsencePlanDEO.ABSENCE_PLAN_ID = AbsencePlanTranslationEO.ABSENCE_PLAN_ID AND AbsencePlanTranslationEO.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG') AND AbsencePlanDEO.EFFECTIVE_START_DATE = AbsencePlanTranslationEO.EFFECTIVE_START_DATE AND AbsencePlanDEO.EFFECTIVE_END_DATE = AbsencePlanTranslationEO.EFFECTIVE_END_DATE

SQL_Statement

SELECT

AbsencePlanDEO.ABSENCE_DURATION_DEFN_ID,

AbsencePlanDEO.ABSENCE_PLAN_ID,

AbsencePlanDEO.ACC_DEFINITION_TYPE,

AbsencePlanDEO.ACC_FORMULA_ID,

AbsencePlanDEO.CARRY_OVER_FLAT_AMT,

AbsencePlanDEO.CARRY_OVER_FORMULA_ID,

AbsencePlanDEO.CARRY_OVER_PRORATE_FORMULA_ID,

AbsencePlanDEO.CEIL_LIMIT_FLAT_AMT,

AbsencePlanDEO.CEIL_LIMIT_FORMULA_ID,

AbsencePlanDEO.CEIL_LMT_PRORATE_FORMULA_ID,

AbsencePlanDEO.EFFECTIVE_END_DATE,

AbsencePlanDEO.EFFECTIVE_START_DATE,

AbsencePlanDEO.ENROLLMENT_END_FORMULA_ID,

AbsencePlanDEO.ENROLLMENT_START_FORMULA_ID,

AbsencePlanDEO.ENTITLEMENT_END_FORMULA_ID,

AbsencePlanDEO.ENTL_DEFINITION_TYPE,

AbsencePlanDEO.ENTL_FORMULA_ID,

AbsencePlanDEO.ENTL_METHOD_CD,

AbsencePlanDEO.LEGISLATION_CODE,

AbsencePlanDEO.LEGISLATIVE_DATA_GROUP_ID,

AbsencePlanDEO.OVERLAP_CD,

AbsencePlanDEO.PAY_RATE_FACTOR,

AbsencePlanDEO.PLAN_MGMT_CD,

AbsencePlanDEO.PLAN_PERIOD_ID,

AbsencePlanDEO.PLAN_PERIOD_TYPE,

AbsencePlanDEO.PLAN_STATUS,

AbsencePlanDEO.PLAN_UOM,

AbsencePlanDEO.PROCESSING_LEVEL_CD,

AbsencePlanDEO.PRORATION_FORMULA_ID,

AbsencePlanDEO.VESTING_PERIOD_FORMULA_ID,

AbsencePlanTranslationEO.DESCRIPTION,

AbsencePlanTranslationEO.LANGUAGE,

AbsencePlanTranslationEO.NAME,

AbsencePlanTranslationEO.SOURCE_LANG,

AbsencePlanDEO.PAY_ADVANCES_FLAG,

AbsencePlanDEO.ENROLL_TERMINATE_ENTL_FLAG,

AbsencePlanDEO.ENROLL_POSITIVE_BALANCE_FLAG,

AbsencePlanDEO.ENROLL_NEGATIVE_BALANCE_FLAG,

AbsencePlanDEO.EMP_ENRL_TERMINATE_ENTL_FLAG,

AbsencePlanDEO.EMP_ENRL_POSITIVE_BALANCE_FLAG,

AbsencePlanDEO.EMP_ENRL_NEGATIVE_BALANCE_FLAG,

AbsencePlanDEO.ENTERPRISE_ID,

AbsencePlanDEO.PERIOD_UOM,

AbsencePlanDEO.OBJECT_VERSION_NUMBER,

AbsencePlanDEO.ACCRUAL_VESTING_CD,

AbsencePlanDEO.ROLL_PERIOD_DURATION,

AbsencePlanDEO.ROLL_FORWARD_START_RULE,

AbsencePlanDEO.ROLL_FORWARD_START_FORMULA_ID,

AbsencePlanDEO.ROLL_BACKWARD_END_RULE,

AbsencePlanDEO.ROLL_BACKWARD_END_FORMULA_ID,

AbsencePlanDEO.PRORATION_RULE,

AbsencePlanDEO.ENTITLEMENT_END_RULE,

AbsencePlanDEO.ENROLLMENT_START_RULE,

AbsencePlanDEO.ENROLLMENT_END_RULE,

AbsencePlanDEO.EXPIRATION_TERM_CD,

AbsencePlanDEO.EXPIRATION_LIMIT,

AbsencePlanDEO.EXPIRATION_UOM_CD,

AbsencePlanDEO.EXPIRATION_ACTION_CD,

AbsencePlanDEO.MGR_EXPIRATION_UPDATE,

AbsencePlanDEO.ADMIN_EXPIRATION_UPDATE,

AbsencePlanDEO.COMP_MNUL_ADJRSN,

AbsencePlanDEO.COMP_EXP_ADJRSN,

AbsencePlanDEO.CEIL_LIMIT_RULE,

AbsencePlanDEO.CEIL_LIMIT_PRORATE_RULE,

AbsencePlanDEO.CARRY_OVER_RULE,

AbsencePlanDEO.CARRY_OVER_PRORATE_RULE,

AbsencePlanDEO.CARRY_OVER_EXPIRED_UOM,

AbsencePlanDEO.CARRY_OVER_EXPIRED_UNITS,

AbsencePlanDEO.CARRY_OVER_EXPIRED_FLAG,

AbsencePlanDEO.CALENDAR_START_MONTH,

AbsencePlanDEO.CALENDAR_START_DAY,

AbsencePlanDEO.ANNIVERSARY_EVENT_RULE,

AbsencePlanDEO.ANNIVERSARY_EVENT_FORMULA_ID,

AbsencePlanDEO.ACC_PERIOD_WFM_CALEDAR_ID,

AbsencePlanDEO.ACC_PERIOD_PAYROLL_FREQ_ID,

AbsencePlanDEO.ACC_PERIOD_FREQUENCY,

AbsencePlanDEO.WAIT_PERIOD_DUR_UNITS,

AbsencePlanDEO.WAIT_PERIOD_DUR_UOM,

AbsencePlanDEO.ACC_NEGATIVE_BAL_FLAG,

AbsencePlanDEO.ACC_NEGATIVE_BAL_LIMIT,

AbsencePlanDEO.ACC_NEGATIVE_BAL_UOM,

AbsencePlanDEO.ANC_ABSENCE_PLANS_F_ALTCD,

AbsencePlanDEO.STATUTORY_FLAG,

AbsencePlanDEO.ACCRUAL_MODE,

AbsencePlanDEO.OTHER_ADJUSTMENT_FLAG,

AbsencePlanDEO.OTHER_REASONS,

AbsencePlanDEO.PAYOUT_RATE_FORMULA_ID,

AbsencePlanDEO.PAYOUT_RATE_RULE,

AbsencePlanDEO.PAYROLL_IMPACT_FLAG,

AbsencePlanDEO.PAYROLL_MAPPING_ID,

AbsencePlanDEO.PLAN_ACTIVATION_FLAG,

AbsencePlanDEO.PREV_EMP_USAGE_FLAG,

AbsencePlanDEO.PREV_EMP_ENTL_FLAG,

AbsencePlanDEO.PLAN_USE_FORMULA_ID,

AbsencePlanDEO.PLAN_USE_RATE_RULE,

AbsencePlanDEO.CASH_OUT_FLAG,

AbsencePlanDEO.CASHOUT_RATE_FORMULA_ID,

AbsencePlanDEO.CASHOUT_RATE_RULE,

AbsencePlanDEO.BALANCE_TRANSFER_FLAG,

AbsencePlanDEO.PLAN_USE_RATE_ID,

AbsencePlanDEO.CASHOUT_RATE_ID,

AbsencePlanDEO.LIABILITY_RATE_FORMULA_ID,

AbsencePlanDEO.LIABILITY_RATE_ID,

AbsencePlanDEO.LIABILITY_RATE_RULE,

AbsencePlanDEO.PAYOUT_RATE_ID,

AbsencePlanDEO.ABSENCE_DURATION_FORMULA_ID,

AbsencePlanDEO.EVAL_ENTITLEMENT_FLAG,

AbsencePlanDEO.DISABLE_ENT_OVERRIDE_FLAG,

AbsencePlanDEO.LEG_GROUPING_CD,

AbsencePlanDEO.BASE_NAME,

AbsencePlanDEO.SGUID SGUID,

AbsencePlanDEO.MGR_MANUAL_ADJUSTMENT,

AbsencePlanDEO.ADMIN_MANUAL_ADJUSTMENT,

AbsencePlanDEO.ACC_LMT_RULE,

AbsencePlanDEO.ACC_LMT_FLAT_AMT,

AbsencePlanDEO.ACC_LIMIT_FORMULA_ID,

AbsencePlanDEO.ACC_LIMIT_PRORATE_RULE,

AbsencePlanDEO.ACC_LMT_PRORATE_FORMULA_ID,

AbsencePlanDEO.RE_ENRL_BAL_LMT,

AbsencePlanDEO.TIME_FRAME_LMT,

AbsencePlanDEO.TIME_FRAME_UOM,

AbsencePlanDEO.ACC_EMP_BAL_DISPLAY,

AbsencePlanDEO.ACC_MGR_BAL_DISPLAY,

AbsencePlanDEO.RE_INSTATEMENT_FLAG,

AbsencePlanDEO.BEN_IMPACT_FLAG,

AbsencePlanDEO.PENDING_DISBURSE_FLAG,

AbsencePlanDEO.ELECTION_DATE_RULE,

AbsencePlanDEO.TRANSFR_POSITIVE_BALANCE_FLAG,

AbsencePlanDEO.TRANSFR_LMT_RULE,

AbsencePlanDEO.TRANSFR_LMT_FLAT_AMT,

AbsencePlanDEO.TRANSFR_LMT_FORMULA_ID,

AbsencePlanDEO.TRANSFR_LMT_PRORATE_RULE,

AbsencePlanDEO.TRANSFR_LMT_PRORATE_FORMULA_ID,

AbsencePlanDEO.TRANSFR_PLAN_CATEGORY,

AbsencePlanDEO.TRANSFR_TARGET_FORMULA_ID,

AbsencePlanDEO.ROLLOVR_LMT_RULE,

AbsencePlanDEO.ROLLOVR_LMT_FLAT_AMT,

AbsencePlanDEO.ROLLOVR_LMT_FORMULA_ID,

AbsencePlanDEO.ROLLOVR_LMT_PRORATE_RULE,

AbsencePlanDEO.ROLLOVR_LMT_PRORATE_FORMULA_ID,

AbsencePlanDEO.ROLLOVR_TARGET_PLAN,

AbsencePlanDEO.ROLLOVR_PLAN_CONVERSION_RATE,

AbsencePlanDEO.YEAR_END_BALANCE_DISBURSE_FLAG,

AbsencePlanDEO.ELECT_DISB_PAY_RATE_FACTOR,

AbsencePlanDEO.YREND_DISB_PAY_RATE_FACTOR,

AbsencePlanDEO.ELECT_DISB_VALID_FORMULA_ID,

AbsencePlanDEO.YREND_DISB_VALID_FORMULA_ID,

AbsencePlanDEO.COMP_MGR_MANUAL_ADJ,

AbsencePlanDEO.ALLOW_CASHOUT_COVR_ADMIN,

AbsencePlanDEO.ALLOW_CASHOUT_COVR_MGR,

AbsencePlanDEO.ALLOW_CASHOUT_COVR_EMP,

AbsencePlanDEO.PARTIAL_ACCRUAL_PRORATION_RULE,

AbsencePlanDEO.PARTIAL_ACCRUAL_FORMULA_ID,

AbsencePlanDEO.ROUNDING_RULE,

AbsencePlanDEO.ROUNDING_PRECISION,

AbsencePlanDEO.ACCRUAL_POSTING_CD,

AbsencePlanDEO.GT_ENROLL_POSITIVE_BAL_FLAG,

AbsencePlanDEO.GT_ENROLL_NEGATIVE_BAL_FLAG,

AbsencePlanDEO.GT_TRANSFR_POSTIVE_BAL_FLAG,

AbsencePlanDEO.GT_ROLLOVER_POSTIVE_BAL_FLAG,

AbsencePlanDEO.GT_TRANSFR_LMT_RULE,

AbsencePlanDEO.GT_TRANSFR_LMT_FLAT_AMT,

AbsencePlanDEO.GT_TRANSFR_LMT_FORMULA_ID,

AbsencePlanDEO.GT_TRANSFR_LMT_PRORATE_RULE,

AbsencePlanDEO.GT_TRFR_LMT_PRORATE_FORMULA_ID,

AbsencePlanDEO.GT_TRANSFR_PLAN_CATEGORY,

AbsencePlanDEO.GT_TRFR_TARGET_FORMULA_ID,

AbsencePlanDEO.GT_TRANSFR_TO_RULES,

AbsencePlanDEO.GT_ROLLOVER_TARGET_PLAN,

AbsencePlanDEO.GT_ROLLOVER_LMT_RULE,

AbsencePlanDEO.GT_ROLLOVER_LMT_FLAT_AMT,

AbsencePlanDEO.GT_ROLLOVER_LMT_FORMULA_ID,

AbsencePlanDEO.GT_ROLLOVER_PLAN_CONV_RATE,

AbsencePlanDEO.GT_ROLL_PRORATE_LMT_RULE,

AbsencePlanDEO.GT_ROLL_PRORATE_LMT_FRMLA_ID,

AbsencePlanDEO.GT_ROLLOVER_TARGET_PLAN_ID,

AbsencePlanDEO.ELIG_ROLLOVER_POSTIVE_BAL_FLAG,

AbsencePlanDEO.ELIG_ROLLOVER_TARGET_PLAN,

AbsencePlanDEO.ELIG_ROLLOVER_LMT_RULE,

AbsencePlanDEO.ELIG_ROLLOVER_LMT_FLAT_AMT,

AbsencePlanDEO.ELIG_ROLLOVER_LMT_FORMULA_ID,

AbsencePlanDEO.ELIG_ROLLOVER_PLAN_CONV_RATE,

AbsencePlanDEO.ELIG_ROLLOVER_PLAN_CONVR_RATE,

AbsencePlanDEO.ELIG_ROLL_PRORATE_LMT_RULE,

AbsencePlanDEO.ELIG_ROLL_PRORATE_LMT_FRMLA_ID,

AbsencePlanDEO.ELIG_ROLLOVER_TARGET_PLAN_ID,

AbsencePlanDEO.ELIG_RETAIN_CARRYOVER_BAL_FLAG,

AbsencePlanDEO.GT_RETAIN_CARRYOVER_BAL_FLAG,

AbsencePlanDEO.DONATION_TYPE,

AbsencePlanDEO.RTN_PSTV_BAL_TO_POOL_FLAG,

AbsencePlanDEO.RATE_DATE_RULE,

AbsencePlanDEO.ELIG_FORFT_BALANCE_FLAG,

AbsencePlanDEO.GT_FORFT_BALANCE_FLAG,

AbsencePlanDEO.TERM_FORFT_BALANCE_FLAG

FROM

ANC_ABSENCE_PLANS_F AbsencePlanDEO,

ANC_ABSENCE_PLANS_F_TL AbsencePlanTranslationEO

WHERE

AbsencePlanDEO.ABSENCE_PLAN_ID = AbsencePlanTranslationEO.ABSENCE_PLAN_ID AND AbsencePlanTranslationEO.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG') AND AbsencePlanDEO.EFFECTIVE_START_DATE = AbsencePlanTranslationEO.EFFECTIVE_START_DATE AND AbsencePlanDEO.EFFECTIVE_END_DATE = AbsencePlanTranslationEO.EFFECTIVE_END_DATE