PER_ACCRUAL_PLANS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
ACCRUAL_PLAN_ID ENTERPRISE_ID LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ACCRUAL_PLAN_NAME ACCRUAL_CATEGORY ACCRUAL_START_RULE ACCRUAL_UNITS DESCRIPTION ACCRUAL_ELEMENT_TYPE_ID CO_INPUT_VALUE_ID CO_DATE_INPUT_VALUE_ID CO_EXP_DATE_INPUT_VALUE_ID RESIDUAL_INPUT_VALUE_ID RESIDUAL_DATE_INPUT_VALUE_ID TAGGING_ELEMENT_TYPE_ID ACCRUAL_DEFINED_BALANCE_ID ACCRUAL_BALANCE_ELEMENT_ID LIABILITY_DEFINED_BALANCE_ID LIABILITY_BALANCE_ELEMENT_ID ACCRUAL_TERM_TYPE ACCRUAL_TERM_LENGTH ACCRUAL_TERM_LENGTH_UOM ACCRUAL_FREQUENCY_TYPE ACCRUAL_FREQUENCY_LENGTH ACCRUAL_FREQUENCY_LENGTH_UOM ACCRUAL_TERM_START ACCRUAL_TERM_END CO_EXPIRY_LENGTH CO_EXPIRY_LENGTH_UOM INELIGIBLE_PERIOD_LENGTH INELIGIBLE_PERIOD_LENGTH_UOM ACCRUAL_FORMULA_ID CO_FORMULA_ID PAYROLL_FORMULA_ID INELIGIBILITY_FORMULA_ID ACCRUAL_BAND_GROUP ACCRUAL_BAND_RANGE 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 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER INFORMATION_NUMBER1 INFORMATION_NUMBER2 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

Name

ACCRUAL_PLAN_ID

ENTERPRISE_ID

LEGISLATIVE_DATA_GROUP_ID

LEGISLATION_CODE

ACCRUAL_PLAN_NAME

ACCRUAL_CATEGORY

ACCRUAL_START_RULE

ACCRUAL_UNITS

DESCRIPTION

ACCRUAL_ELEMENT_TYPE_ID

CO_INPUT_VALUE_ID

CO_DATE_INPUT_VALUE_ID

CO_EXP_DATE_INPUT_VALUE_ID

RESIDUAL_INPUT_VALUE_ID

RESIDUAL_DATE_INPUT_VALUE_ID

TAGGING_ELEMENT_TYPE_ID

ACCRUAL_DEFINED_BALANCE_ID

ACCRUAL_BALANCE_ELEMENT_ID

LIABILITY_DEFINED_BALANCE_ID

LIABILITY_BALANCE_ELEMENT_ID

ACCRUAL_TERM_TYPE

ACCRUAL_TERM_LENGTH

ACCRUAL_TERM_LENGTH_UOM

ACCRUAL_FREQUENCY_TYPE

ACCRUAL_FREQUENCY_LENGTH

ACCRUAL_FREQUENCY_LENGTH_UOM

ACCRUAL_TERM_START

ACCRUAL_TERM_END

CO_EXPIRY_LENGTH

CO_EXPIRY_LENGTH_UOM

INELIGIBLE_PERIOD_LENGTH

INELIGIBLE_PERIOD_LENGTH_UOM

ACCRUAL_FORMULA_ID

CO_FORMULA_ID

PAYROLL_FORMULA_ID

INELIGIBILITY_FORMULA_ID

ACCRUAL_BAND_GROUP

ACCRUAL_BAND_RANGE

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

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

INFORMATION_NUMBER1

INFORMATION_NUMBER2

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

Query

SQL_Statement
SELECT APN.ACCRUAL_PLAN_ID, APN.ENTERPRISE_ID, APN.LEGISLATIVE_DATA_GROUP_ID, APN.LEGISLATION_CODE, APNTL.ACCRUAL_PLAN_NAME, APN.ACCRUAL_CATEGORY, APN.ACCRUAL_START_RULE, APN.ACCRUAL_UNITS, APNTL.DESCRIPTION, APN.ACCRUAL_ELEMENT_TYPE_ID, APN.CO_INPUT_VALUE_ID, APN.CO_DATE_INPUT_VALUE_ID, APN.CO_EXP_DATE_INPUT_VALUE_ID, APN.RESIDUAL_INPUT_VALUE_ID, APN.RESIDUAL_DATE_INPUT_VALUE_ID, APN.TAGGING_ELEMENT_TYPE_ID, APN.ACCRUAL_DEFINED_BALANCE_ID, APN.ACCRUAL_BALANCE_ELEMENT_ID, APN.LIABILITY_DEFINED_BALANCE_ID, APN.LIABILITY_BALANCE_ELEMENT_ID, APN.ACCRUAL_TERM_TYPE, APN.ACCRUAL_TERM_LENGTH, APN.ACCRUAL_TERM_LENGTH_UOM, APN.ACCRUAL_FREQUENCY_TYPE, APN.ACCRUAL_FREQUENCY_LENGTH, APN.ACCRUAL_FREQUENCY_LENGTH_UOM, APN.ACCRUAL_TERM_START, APN.ACCRUAL_TERM_END, APN.CO_EXPIRY_LENGTH, APN.CO_EXPIRY_LENGTH_UOM, APN.INELIGIBLE_PERIOD_LENGTH, APN.INELIGIBLE_PERIOD_LENGTH_UOM, APN.ACCRUAL_FORMULA_ID, APN.CO_FORMULA_ID, APN.PAYROLL_FORMULA_ID, APN.INELIGIBILITY_FORMULA_ID, APN.ACCRUAL_BAND_GROUP, APN.ACCRUAL_BAND_RANGE, APN.INFORMATION_CATEGORY, APN.INFORMATION1, APN.INFORMATION2, APN.INFORMATION3, APN.INFORMATION4, APN.INFORMATION5, APN.INFORMATION6, APN.INFORMATION7, APN.INFORMATION8, APN.INFORMATION9, APN.INFORMATION10, APN.INFORMATION11, APN.INFORMATION12, APN.INFORMATION13, APN.INFORMATION14, APN.INFORMATION15, APN.INFORMATION16, APN.INFORMATION17, APN.INFORMATION18, APN.INFORMATION19, APN.INFORMATION20, APN.INFORMATION21, APN.INFORMATION22, APN.INFORMATION23, APN.INFORMATION24, APN.INFORMATION25, APN.INFORMATION26, APN.INFORMATION27, APN.INFORMATION28, APN.INFORMATION29, APN.INFORMATION30, APN.CREATED_BY, APN.CREATION_DATE, APN.LAST_UPDATED_BY, APN.LAST_UPDATE_DATE, APN.LAST_UPDATE_LOGIN, APN.OBJECT_VERSION_NUMBER, APN.INFORMATION_NUMBER1, APN.INFORMATION_NUMBER2, APN.INFORMATION_NUMBER3, APN.INFORMATION_NUMBER4, APN.INFORMATION_NUMBER5, APN.INFORMATION_NUMBER6, APN.INFORMATION_NUMBER7, APN.INFORMATION_NUMBER8, APN.INFORMATION_NUMBER9, APN.INFORMATION_NUMBER10, APN.INFORMATION_NUMBER11, APN.INFORMATION_NUMBER12, APN.INFORMATION_NUMBER13, APN.INFORMATION_NUMBER14, APN.INFORMATION_NUMBER15, APN.INFORMATION_NUMBER16, APN.INFORMATION_NUMBER17, APN.INFORMATION_NUMBER18, APN.INFORMATION_NUMBER19, APN.INFORMATION_NUMBER20, APN.INFORMATION_DATE1, APN.INFORMATION_DATE2, APN.INFORMATION_DATE3, APN.INFORMATION_DATE4, APN.INFORMATION_DATE5, APN.INFORMATION_DATE6, APN.INFORMATION_DATE7, APN.INFORMATION_DATE8, APN.INFORMATION_DATE9, APN.INFORMATION_DATE10, APN.INFORMATION_DATE11, APN.INFORMATION_DATE12, APN.INFORMATION_DATE13, APN.INFORMATION_DATE14, APN.INFORMATION_DATE15 FROM PER_ACCRUAL_PLANS_B APN, PER_ACCRUAL_PLANS_TL APNTL WHERE APNTL.ACCRUAL_PLAN_ID = APN.ACCRUAL_PLAN_ID AND APNTL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

APN.ACCRUAL_PLAN_ID,

APN.ENTERPRISE_ID,

APN.LEGISLATIVE_DATA_GROUP_ID,

APN.LEGISLATION_CODE,

APNTL.ACCRUAL_PLAN_NAME,

APN.ACCRUAL_CATEGORY,

APN.ACCRUAL_START_RULE,

APN.ACCRUAL_UNITS,

APNTL.DESCRIPTION,

APN.ACCRUAL_ELEMENT_TYPE_ID,

APN.CO_INPUT_VALUE_ID,

APN.CO_DATE_INPUT_VALUE_ID,

APN.CO_EXP_DATE_INPUT_VALUE_ID,

APN.RESIDUAL_INPUT_VALUE_ID,

APN.RESIDUAL_DATE_INPUT_VALUE_ID,

APN.TAGGING_ELEMENT_TYPE_ID,

APN.ACCRUAL_DEFINED_BALANCE_ID,

APN.ACCRUAL_BALANCE_ELEMENT_ID,

APN.LIABILITY_DEFINED_BALANCE_ID,

APN.LIABILITY_BALANCE_ELEMENT_ID,

APN.ACCRUAL_TERM_TYPE,

APN.ACCRUAL_TERM_LENGTH,

APN.ACCRUAL_TERM_LENGTH_UOM,

APN.ACCRUAL_FREQUENCY_TYPE,

APN.ACCRUAL_FREQUENCY_LENGTH,

APN.ACCRUAL_FREQUENCY_LENGTH_UOM,

APN.ACCRUAL_TERM_START,

APN.ACCRUAL_TERM_END,

APN.CO_EXPIRY_LENGTH,

APN.CO_EXPIRY_LENGTH_UOM,

APN.INELIGIBLE_PERIOD_LENGTH,

APN.INELIGIBLE_PERIOD_LENGTH_UOM,

APN.ACCRUAL_FORMULA_ID,

APN.CO_FORMULA_ID,

APN.PAYROLL_FORMULA_ID,

APN.INELIGIBILITY_FORMULA_ID,

APN.ACCRUAL_BAND_GROUP,

APN.ACCRUAL_BAND_RANGE,

APN.INFORMATION_CATEGORY,

APN.INFORMATION1,

APN.INFORMATION2,

APN.INFORMATION3,

APN.INFORMATION4,

APN.INFORMATION5,

APN.INFORMATION6,

APN.INFORMATION7,

APN.INFORMATION8,

APN.INFORMATION9,

APN.INFORMATION10,

APN.INFORMATION11,

APN.INFORMATION12,

APN.INFORMATION13,

APN.INFORMATION14,

APN.INFORMATION15,

APN.INFORMATION16,

APN.INFORMATION17,

APN.INFORMATION18,

APN.INFORMATION19,

APN.INFORMATION20,

APN.INFORMATION21,

APN.INFORMATION22,

APN.INFORMATION23,

APN.INFORMATION24,

APN.INFORMATION25,

APN.INFORMATION26,

APN.INFORMATION27,

APN.INFORMATION28,

APN.INFORMATION29,

APN.INFORMATION30,

APN.CREATED_BY,

APN.CREATION_DATE,

APN.LAST_UPDATED_BY,

APN.LAST_UPDATE_DATE,

APN.LAST_UPDATE_LOGIN,

APN.OBJECT_VERSION_NUMBER,

APN.INFORMATION_NUMBER1,

APN.INFORMATION_NUMBER2,

APN.INFORMATION_NUMBER3,

APN.INFORMATION_NUMBER4,

APN.INFORMATION_NUMBER5,

APN.INFORMATION_NUMBER6,

APN.INFORMATION_NUMBER7,

APN.INFORMATION_NUMBER8,

APN.INFORMATION_NUMBER9,

APN.INFORMATION_NUMBER10,

APN.INFORMATION_NUMBER11,

APN.INFORMATION_NUMBER12,

APN.INFORMATION_NUMBER13,

APN.INFORMATION_NUMBER14,

APN.INFORMATION_NUMBER15,

APN.INFORMATION_NUMBER16,

APN.INFORMATION_NUMBER17,

APN.INFORMATION_NUMBER18,

APN.INFORMATION_NUMBER19,

APN.INFORMATION_NUMBER20,

APN.INFORMATION_DATE1,

APN.INFORMATION_DATE2,

APN.INFORMATION_DATE3,

APN.INFORMATION_DATE4,

APN.INFORMATION_DATE5,

APN.INFORMATION_DATE6,

APN.INFORMATION_DATE7,

APN.INFORMATION_DATE8,

APN.INFORMATION_DATE9,

APN.INFORMATION_DATE10,

APN.INFORMATION_DATE11,

APN.INFORMATION_DATE12,

APN.INFORMATION_DATE13,

APN.INFORMATION_DATE14,

APN.INFORMATION_DATE15

FROM

PER_ACCRUAL_PLANS_B APN,

PER_ACCRUAL_PLANS_TL APNTL

WHERE

APNTL.ACCRUAL_PLAN_ID = APN.ACCRUAL_PLAN_ID AND APNTL.LANGUAGE = USERENV('LANG')