Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_BALANCE_CATEGORIES_F_FV |
SELECT B.ROW_ID
, B.BALANCE_CATEGORY_ID
, B.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_VL B
WHERE B.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND B.EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID'))