VIEW: APPS.HRBV_BUDGET_VALUES_V

Source

View Text - Preformatted

SELECT BDV.VALUE, BDV.PROGRAM_UPDATE_DATE, BDV.INFORMATION_CATEGORY, BDV.BUDGET_INFORMATION1, BDV.BUDGET_INFORMATION2, BDV.BUDGET_INFORMATION3, BDV.BUDGET_INFORMATION4, BDV.BUDGET_INFORMATION5, BDV.BUDGET_INFORMATION6, BDV.BUDGET_INFORMATION7, BDV.BUDGET_INFORMATION8, BDV.BUDGET_INFORMATION9, BDV.BUDGET_INFORMATION10, BDV.BUDGET_INFORMATION11, BDV.BUDGET_INFORMATION12, BDV.BUDGET_INFORMATION13, BDV.BUDGET_INFORMATION14, BDV.BUDGET_INFORMATION15, BDV.BUDGET_INFORMATION16, BDV.BUDGET_INFORMATION17, BDV.BUDGET_INFORMATION18, BDV.BUDGET_INFORMATION19, BDV.BUDGET_INFORMATION20, BDV.BUDGET_INFORMATION21, BDV.BUDGET_INFORMATION22, BDV.BUDGET_INFORMATION23, BDV.BUDGET_INFORMATION24, BDV.BUDGET_INFORMATION25, BDV.BUDGET_INFORMATION26, BDV.BUDGET_INFORMATION27, BDV.BUDGET_INFORMATION28, BDV.BUDGET_INFORMATION29, BDV.BUDGET_INFORMATION30, '_DF:PER:PER_BUDGET_VALUES:BDV', HR_API.RETURN_LEGISLATION_CODE(BDV.BUSINESS_GROUP_ID) LEGISLATION_CODE, BDV.BUDGET_VALUE_ID, BDV.BUSINESS_GROUP_ID, BDV.BUDGET_ELEMENT_ID, BDV.TIME_PERIOD_ID, BDV.LAST_UPDATE_DATE, BDV.LAST_UPDATED_BY, BDV.CREATED_BY, BDV.CREATION_DATE, CASE WHEN BDV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, BDV.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_BUDGET_VALUES BDV WITH READ ONLY

View Text - HTML Formatted

SELECT BDV.VALUE
, BDV.PROGRAM_UPDATE_DATE
, BDV.INFORMATION_CATEGORY
, BDV.BUDGET_INFORMATION1
, BDV.BUDGET_INFORMATION2
, BDV.BUDGET_INFORMATION3
, BDV.BUDGET_INFORMATION4
, BDV.BUDGET_INFORMATION5
, BDV.BUDGET_INFORMATION6
, BDV.BUDGET_INFORMATION7
, BDV.BUDGET_INFORMATION8
, BDV.BUDGET_INFORMATION9
, BDV.BUDGET_INFORMATION10
, BDV.BUDGET_INFORMATION11
, BDV.BUDGET_INFORMATION12
, BDV.BUDGET_INFORMATION13
, BDV.BUDGET_INFORMATION14
, BDV.BUDGET_INFORMATION15
, BDV.BUDGET_INFORMATION16
, BDV.BUDGET_INFORMATION17
, BDV.BUDGET_INFORMATION18
, BDV.BUDGET_INFORMATION19
, BDV.BUDGET_INFORMATION20
, BDV.BUDGET_INFORMATION21
, BDV.BUDGET_INFORMATION22
, BDV.BUDGET_INFORMATION23
, BDV.BUDGET_INFORMATION24
, BDV.BUDGET_INFORMATION25
, BDV.BUDGET_INFORMATION26
, BDV.BUDGET_INFORMATION27
, BDV.BUDGET_INFORMATION28
, BDV.BUDGET_INFORMATION29
, BDV.BUDGET_INFORMATION30
, '_DF:PER:PER_BUDGET_VALUES:BDV'
, HR_API.RETURN_LEGISLATION_CODE(BDV.BUSINESS_GROUP_ID) LEGISLATION_CODE
, BDV.BUDGET_VALUE_ID
, BDV.BUSINESS_GROUP_ID
, BDV.BUDGET_ELEMENT_ID
, BDV.TIME_PERIOD_ID
, BDV.LAST_UPDATE_DATE
, BDV.LAST_UPDATED_BY
, BDV.CREATED_BY
, BDV.CREATION_DATE
, CASE WHEN BDV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BDV.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_BUDGET_VALUES BDV WITH READ ONLY