VIEW: APPS.PER_DEFAULT_BUDGET_VALUES

Source

View Text - Preformatted

SELECT O.BUSINESS_GROUP_ID , O2.ORG_INFORMATION1 , fnd_number.canonical_to_number(O2.ORG_INFORMATION2) FROM HR_ALL_ORGANIZATION_UNITS O , HR_ORGANIZATION_INFORMATION O2 , HR_ORGANIZATION_INFORMATION O3 WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O2.ORG_INFORMATION_CONTEXT = 'Budget Value Defaults' AND O3.ORG_INFORMATION_CONTEXT = 'CLASS' AND O3.ORG_INFORMATION1 = 'HR_BG' AND O3.ORG_INFORMATION2 = 'Y'

View Text - HTML Formatted

SELECT O.BUSINESS_GROUP_ID
, O2.ORG_INFORMATION1
, FND_NUMBER.CANONICAL_TO_NUMBER(O2.ORG_INFORMATION2)
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT = 'BUDGET VALUE DEFAULTS'
AND O3.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_BG'
AND O3.ORG_INFORMATION2 = 'Y'