DBA Data[Home] [Help]

VIEW: APPS.HRBV_BUDGET_VERSIONS_V

Source

View Text - Preformatted

SELECT PBV.DATE_FROM, PBV.VERSION_NUMBER, PBV.COMMENTS, PBV.DATE_TO, '_DF:PER:PER_BUDGET_VERSIONS:PBV', PBV.BUDGET_VERSION_ID, PBV.BUSINESS_GROUP_ID, PBV.BUDGET_ID, PBV.LAST_UPDATE_DATE, PBV.LAST_UPDATED_BY, PBV.CREATED_BY, PBV.CREATION_DATE, CASE WHEN PBV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PBV.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_BUDGET_VERSIONS PBV WITH READ ONLY
View Text - HTML Formatted

SELECT PBV.DATE_FROM
, PBV.VERSION_NUMBER
, PBV.COMMENTS
, PBV.DATE_TO
, '_DF:PER:PER_BUDGET_VERSIONS:PBV'
, PBV.BUDGET_VERSION_ID
, PBV.BUSINESS_GROUP_ID
, PBV.BUDGET_ID
, PBV.LAST_UPDATE_DATE
, PBV.LAST_UPDATED_BY
, PBV.CREATED_BY
, PBV.CREATION_DATE
, CASE WHEN PBV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBV.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_BUDGET_VERSIONS PBV WITH READ ONLY