1. Tables and Views for HCM
  2. PAY_BALANCE_CATEGORIES_VL

PAY_BALANCE_CATEGORIES_VL

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

BALANCE_CATEGORY_ID

BASE_CATEGORY_NAME

USER_CATEGORY_NAME

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

BASE_BALANCE_CATEGORY_ID

ENTERPRISE_ID

LEGISLATION_CODE

LEGISLATIVE_DATA_GROUP_ID

SAVE_RUN_BALANCE_ENABLED

PBC_INFORMATION_CATEGORY

PBC_INFORMATION1

PBC_INFORMATION2

PBC_INFORMATION3

PBC_INFORMATION4

PBC_INFORMATION5

PBC_INFORMATION6

PBC_INFORMATION7

PBC_INFORMATION8

PBC_INFORMATION9

PBC_INFORMATION10

PBC_INFORMATION11

PBC_INFORMATION12

PBC_INFORMATION13

PBC_INFORMATION14

PBC_INFORMATION15

PBC_INFORMATION16

PBC_INFORMATION17

PBC_INFORMATION18

PBC_INFORMATION19

PBC_INFORMATION20

PBC_INFORMATION21

PBC_INFORMATION22

PBC_INFORMATION23

PBC_INFORMATION24

PBC_INFORMATION25

PBC_INFORMATION26

PBC_INFORMATION27

PBC_INFORMATION28

PBC_INFORMATION29

PBC_INFORMATION30

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

MODULE_ID

PBC_INFORMATION_NUMBER1

PBC_INFORMATION_NUMBER2

PBC_INFORMATION_NUMBER3

PBC_INFORMATION_NUMBER4

PBC_INFORMATION_NUMBER5

PBC_INFORMATION_NUMBER6

PBC_INFORMATION_NUMBER7

PBC_INFORMATION_NUMBER8

PBC_INFORMATION_NUMBER9

PBC_INFORMATION_NUMBER10

PBC_INFORMATION_NUMBER11

PBC_INFORMATION_NUMBER12

PBC_INFORMATION_NUMBER13

PBC_INFORMATION_NUMBER14

PBC_INFORMATION_NUMBER15

PBC_INFORMATION_NUMBER16

PBC_INFORMATION_NUMBER17

PBC_INFORMATION_NUMBER18

PBC_INFORMATION_NUMBER19

PBC_INFORMATION_NUMBER20

PBC_INFORMATION_DATE1

PBC_INFORMATION_DATE2

PBC_INFORMATION_DATE3

PBC_INFORMATION_DATE4

PBC_INFORMATION_DATE5

PBC_INFORMATION_DATE6

PBC_INFORMATION_DATE7

PBC_INFORMATION_DATE8

PBC_INFORMATION_DATE9

PBC_INFORMATION_DATE10

PBC_INFORMATION_DATE11

PBC_INFORMATION_DATE12

PBC_INFORMATION_DATE13

PBC_INFORMATION_DATE14

PBC_INFORMATION_DATE15

SGUID

APPLICATION_ID

Query

SQL_Statement

SELECT

pbcf.BALANCE_CATEGORY_ID,

pbcf.BASE_CATEGORY_NAME,

pbcftl.USER_CATEGORY_NAME USER_CATEGORY_NAME,

pbcf.EFFECTIVE_START_DATE,

pbcf.EFFECTIVE_END_DATE,

pbcf.BASE_BALANCE_CATEGORY_ID,

pbcf.ENTERPRISE_ID,

pbcf.LEGISLATION_CODE,

pbcf.LEGISLATIVE_DATA_GROUP_ID,

pbcf.SAVE_RUN_BALANCE_ENABLED,

pbcf.PBC_INFORMATION_CATEGORY,

pbcf.PBC_INFORMATION1,

pbcf.PBC_INFORMATION2,

pbcf.PBC_INFORMATION3,

pbcf.PBC_INFORMATION4,

pbcf.PBC_INFORMATION5,

pbcf.PBC_INFORMATION6,

pbcf.PBC_INFORMATION7,

pbcf.PBC_INFORMATION8,

pbcf.PBC_INFORMATION9,

pbcf.PBC_INFORMATION10,

pbcf.PBC_INFORMATION11,

pbcf.PBC_INFORMATION12,

pbcf.PBC_INFORMATION13,

pbcf.PBC_INFORMATION14,

pbcf.PBC_INFORMATION15,

pbcf.PBC_INFORMATION16,

pbcf.PBC_INFORMATION17,

pbcf.PBC_INFORMATION18,

pbcf.PBC_INFORMATION19,

pbcf.PBC_INFORMATION20,

pbcf.PBC_INFORMATION21,

pbcf.PBC_INFORMATION22,

pbcf.PBC_INFORMATION23,

pbcf.PBC_INFORMATION24,

pbcf.PBC_INFORMATION25,

pbcf.PBC_INFORMATION26,

pbcf.PBC_INFORMATION27,

pbcf.PBC_INFORMATION28,

pbcf.PBC_INFORMATION29,

pbcf.PBC_INFORMATION30,

pbcf.LAST_UPDATE_DATE,

pbcf.LAST_UPDATED_BY,

pbcf.LAST_UPDATE_LOGIN,

pbcf.CREATED_BY,

pbcf.CREATION_DATE,

pbcf.OBJECT_VERSION_NUMBER,

pbcf.MODULE_ID,

pbcf.PBC_INFORMATION_NUMBER1,

pbcf.PBC_INFORMATION_NUMBER2,

pbcf.PBC_INFORMATION_NUMBER3,

pbcf.PBC_INFORMATION_NUMBER4,

pbcf.PBC_INFORMATION_NUMBER5,

pbcf.PBC_INFORMATION_NUMBER6,

pbcf.PBC_INFORMATION_NUMBER7,

pbcf.PBC_INFORMATION_NUMBER8,

pbcf.PBC_INFORMATION_NUMBER9,

pbcf.PBC_INFORMATION_NUMBER10,

pbcf.PBC_INFORMATION_NUMBER11,

pbcf.PBC_INFORMATION_NUMBER12,

pbcf.PBC_INFORMATION_NUMBER13,

pbcf.PBC_INFORMATION_NUMBER14,

pbcf.PBC_INFORMATION_NUMBER15,

pbcf.PBC_INFORMATION_NUMBER16,

pbcf.PBC_INFORMATION_NUMBER17,

pbcf.PBC_INFORMATION_NUMBER18,

pbcf.PBC_INFORMATION_NUMBER19,

pbcf.PBC_INFORMATION_NUMBER20,

pbcf.PBC_INFORMATION_DATE1,

pbcf.PBC_INFORMATION_DATE2,

pbcf.PBC_INFORMATION_DATE3,

pbcf.PBC_INFORMATION_DATE4,

pbcf.PBC_INFORMATION_DATE5,

pbcf.PBC_INFORMATION_DATE6,

pbcf.PBC_INFORMATION_DATE7,

pbcf.PBC_INFORMATION_DATE8,

pbcf.PBC_INFORMATION_DATE9,

pbcf.PBC_INFORMATION_DATE10,

pbcf.PBC_INFORMATION_DATE11,

pbcf.PBC_INFORMATION_DATE12,

pbcf.PBC_INFORMATION_DATE13,

pbcf.PBC_INFORMATION_DATE14,

pbcf.PBC_INFORMATION_DATE15,

pbcf.SGUID SGUID,

pbcf.APPLICATION_ID

FROM

PAY_BALANCE_CATEGORIES_F pbcf,

PAY_BALANCE_CATEGORIES_TL pbcftl

WHERE

pbcftl.BALANCE_CATEGORY_ID = pbcf.BALANCE_CATEGORY_ID AND pbcftl.LANGUAGE = USERENV('LANG')