Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_BALANCE_CATEGORIES_F_VL |
SELECT B.ROWID ROW_ID
, B.BALANCE_CATEGORY_ID
, TL.USER_CATEGORY_NAME
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.LEGISLATION_CODE
, B.BUSINESS_GROUP_ID
, B.SAVE_RUN_BALANCE_ENABLED
, B.USER_CATEGORY_NAME
, B.PBC_INFORMATION_CATEGORY
, B.PBC_INFORMATION1
, B.PBC_INFORMATION2
, B.PBC_INFORMATION3
, B.PBC_INFORMATION4
, B.PBC_INFORMATION5
, B.PBC_INFORMATION6
, B.PBC_INFORMATION7
, B.PBC_INFORMATION8
, B.PBC_INFORMATION9
, B.PBC_INFORMATION10
, B.PBC_INFORMATION11
, B.PBC_INFORMATION12
, B.PBC_INFORMATION13
, B.PBC_INFORMATION14
, B.PBC_INFORMATION15
, B.PBC_INFORMATION16
, B.PBC_INFORMATION17
, B.PBC_INFORMATION18
, B.PBC_INFORMATION19
, B.PBC_INFORMATION20
, B.PBC_INFORMATION21
, B.PBC_INFORMATION22
, B.PBC_INFORMATION23
, B.PBC_INFORMATION24
, B.PBC_INFORMATION25
, B.PBC_INFORMATION26
, B.PBC_INFORMATION27
, B.PBC_INFORMATION28
, B.PBC_INFORMATION29
, B.PBC_INFORMATION30
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
FROM PAY_BALANCE_CATEGORIES_F B
, PAY_BALANCE_CATEGORIES_F_TL TL
WHERE B.BALANCE_CATEGORY_ID = TL.BALANCE_CATEGORY_ID
AND TL.LANGUAGE = USERENV('LANG')