Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_BALANCE_CATEGORIES_F_V |
SELECT PBC.CATEGORY_NAME
, PBC.USER_CATEGORY_NAME
, PBC.EFFECTIVE_START_DATE
, PBC.EFFECTIVE_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PBC.SAVE_RUN_BALANCE_ENABLED) SAVE_RUN_BALANCE_ENABLED_M
, PBC.PBC_INFORMATION_CATEGORY
, PBC.PBC_INFORMATION1
, PBC.PBC_INFORMATION2
, PBC.PBC_INFORMATION3
, PBC.PBC_INFORMATION4
, PBC.PBC_INFORMATION5
, PBC.PBC_INFORMATION6
, PBC.PBC_INFORMATION7
, PBC.PBC_INFORMATION8
, PBC.PBC_INFORMATION9
, PBC.PBC_INFORMATION10
, PBC.PBC_INFORMATION11
, PBC.PBC_INFORMATION12
, PBC.PBC_INFORMATION13
, PBC.PBC_INFORMATION14
, PBC.PBC_INFORMATION15
, PBC.PBC_INFORMATION16
, PBC.PBC_INFORMATION17
, PBC.PBC_INFORMATION18
, PBC.PBC_INFORMATION19
, PBC.PBC_INFORMATION20
, PBC.PBC_INFORMATION21
, PBC.PBC_INFORMATION22
, PBC.PBC_INFORMATION23
, PBC.PBC_INFORMATION24
, PBC.PBC_INFORMATION25
, PBC.PBC_INFORMATION26
, PBC.PBC_INFORMATION27
, PBC.PBC_INFORMATION28
, PBC.PBC_INFORMATION29
, PBC.PBC_INFORMATION30
, PBC.SAVE_RUN_BALANCE_ENABLED
, PBC.LEGISLATION_CODE
, PBC.BUSINESS_GROUP_ID
, PBC.BALANCE_CATEGORY_ID
, PBC.OBJECT_VERSION_NUMBER
, PBC.LAST_UPDATE_DATE
, PBC.LAST_UPDATED_BY
, PBC.LAST_UPDATE_LOGIN
, PBC.CREATED_BY
, PBC.CREATION_DATE
, CASE WHEN ((PBC.BUSINESS_GROUP_ID IS NULL
AND PBC.LEGISLATION_CODE IS NULL) OR (PBC.BUSINESS_GROUP_ID IS NULL
AND PBC.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PBC.LEGISLATION_CODE)) OR (PBC.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_BALANCE_CATEGORIES_F PBC WITH READ ONLY