VIEW: HR.PAY_ACCRUAL_PLANS#

Source

View Text - Preformatted

select ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACCRUAL_PLAN_ELEMENT_TYPE_ID ACCRUAL_PLAN_ELEMENT_TYPE_ID, PTO_INPUT_VALUE_ID PTO_INPUT_VALUE_ID, CO_FORMULA_ID CO_FORMULA_ID, CO_INPUT_VALUE_ID CO_INPUT_VALUE_ID, CO_DATE_INPUT_VALUE_ID CO_DATE_INPUT_VALUE_ID, CO_EXP_DATE_INPUT_VALUE_ID CO_EXP_DATE_INPUT_VALUE_ID, RESIDUAL_INPUT_VALUE_ID RESIDUAL_INPUT_VALUE_ID, RESIDUAL_DATE_INPUT_VALUE_ID RESIDUAL_DATE_INPUT_VALUE_ID, ACCRUAL_FORMULA_ID ACCRUAL_FORMULA_ID, ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME, ACCRUAL_CATEGORY ACCRUAL_CATEGORY, ACCRUAL_START ACCRUAL_START, ACCRUAL_UNITS_OF_MEASURE ACCRUAL_UNITS_OF_MEASURE, INELIGIBLE_PERIOD_LENGTH INELIGIBLE_PERIOD_LENGTH, INELIGIBLE_PERIOD_TYPE INELIGIBLE_PERIOD_TYPE, DESCRIPTION DESCRIPTION, INELIGIBILITY_FORMULA_ID INELIGIBILITY_FORMULA_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, PAYROLL_FORMULA_ID PAYROLL_FORMULA_ID, DEFINED_BALANCE_ID DEFINED_BALANCE_ID, TAGGING_ELEMENT_TYPE_ID TAGGING_ELEMENT_TYPE_ID, BALANCE_ELEMENT_TYPE_ID BALANCE_ELEMENT_TYPE_ID, INFORMATION_CATEGORY INFORMATION_CATEGORY, INFORMATION1 INFORMATION1, INFORMATION2 INFORMATION2, INFORMATION3 INFORMATION3, INFORMATION4 INFORMATION4, INFORMATION5 INFORMATION5, INFORMATION6 INFORMATION6, INFORMATION7 INFORMATION7, INFORMATION8 INFORMATION8, INFORMATION9 INFORMATION9, INFORMATION10 INFORMATION10, INFORMATION11 INFORMATION11, INFORMATION12 INFORMATION12, INFORMATION13 INFORMATION13, INFORMATION14 INFORMATION14, INFORMATION15 INFORMATION15, INFORMATION16 INFORMATION16, INFORMATION17 INFORMATION17, INFORMATION18 INFORMATION18, INFORMATION19 INFORMATION19, INFORMATION20 INFORMATION20, INFORMATION21 INFORMATION21, INFORMATION22 INFORMATION22, INFORMATION23 INFORMATION23, INFORMATION24 INFORMATION24, INFORMATION25 INFORMATION25, INFORMATION26 INFORMATION26, INFORMATION27 INFORMATION27, INFORMATION28 INFORMATION28, INFORMATION29 INFORMATION29, INFORMATION30 INFORMATION30 from "HR"."PAY_ACCRUAL_PLANS"

View Text - HTML Formatted

SELECT ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACCRUAL_PLAN_ELEMENT_TYPE_ID ACCRUAL_PLAN_ELEMENT_TYPE_ID
, PTO_INPUT_VALUE_ID PTO_INPUT_VALUE_ID
, CO_FORMULA_ID CO_FORMULA_ID
, CO_INPUT_VALUE_ID CO_INPUT_VALUE_ID
, CO_DATE_INPUT_VALUE_ID CO_DATE_INPUT_VALUE_ID
, CO_EXP_DATE_INPUT_VALUE_ID CO_EXP_DATE_INPUT_VALUE_ID
, RESIDUAL_INPUT_VALUE_ID RESIDUAL_INPUT_VALUE_ID
, RESIDUAL_DATE_INPUT_VALUE_ID RESIDUAL_DATE_INPUT_VALUE_ID
, ACCRUAL_FORMULA_ID ACCRUAL_FORMULA_ID
, ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME
, ACCRUAL_CATEGORY ACCRUAL_CATEGORY
, ACCRUAL_START ACCRUAL_START
, ACCRUAL_UNITS_OF_MEASURE ACCRUAL_UNITS_OF_MEASURE
, INELIGIBLE_PERIOD_LENGTH INELIGIBLE_PERIOD_LENGTH
, INELIGIBLE_PERIOD_TYPE INELIGIBLE_PERIOD_TYPE
, DESCRIPTION DESCRIPTION
, INELIGIBILITY_FORMULA_ID INELIGIBILITY_FORMULA_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, PAYROLL_FORMULA_ID PAYROLL_FORMULA_ID
, DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, TAGGING_ELEMENT_TYPE_ID TAGGING_ELEMENT_TYPE_ID
, BALANCE_ELEMENT_TYPE_ID BALANCE_ELEMENT_TYPE_ID
, INFORMATION_CATEGORY INFORMATION_CATEGORY
, INFORMATION1 INFORMATION1
, INFORMATION2 INFORMATION2
, INFORMATION3 INFORMATION3
, INFORMATION4 INFORMATION4
, INFORMATION5 INFORMATION5
, INFORMATION6 INFORMATION6
, INFORMATION7 INFORMATION7
, INFORMATION8 INFORMATION8
, INFORMATION9 INFORMATION9
, INFORMATION10 INFORMATION10
, INFORMATION11 INFORMATION11
, INFORMATION12 INFORMATION12
, INFORMATION13 INFORMATION13
, INFORMATION14 INFORMATION14
, INFORMATION15 INFORMATION15
, INFORMATION16 INFORMATION16
, INFORMATION17 INFORMATION17
, INFORMATION18 INFORMATION18
, INFORMATION19 INFORMATION19
, INFORMATION20 INFORMATION20
, INFORMATION21 INFORMATION21
, INFORMATION22 INFORMATION22
, INFORMATION23 INFORMATION23
, INFORMATION24 INFORMATION24
, INFORMATION25 INFORMATION25
, INFORMATION26 INFORMATION26
, INFORMATION27 INFORMATION27
, INFORMATION28 INFORMATION28
, INFORMATION29 INFORMATION29
, INFORMATION30 INFORMATION30
FROM "HR"."PAY_ACCRUAL_PLANS"