VIEW: APPS.PSP_ORGANIZATIONS_EXPEND_V

Source

View Text - Preformatted

SELECT HAO.ORGANIZATION_ID, HAO.BUSINESS_GROUP_ID, HAOTL.NAME, HAO.DATE_FROM, HAO.DATE_TO, ORG_ID FROM HR_ALL_ORGANIZATION_UNITS HAO, HR_ALL_ORGANIZATION_UNITS_TL HAOTL, PA_ALL_ORGANIZATIONS PAORG WHERE DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y', HAO.BUSINESS_GROUP_ID , HR_GENERAL.GET_BUSINESS_GROUP_ID) = HAO.BUSINESS_GROUP_ID AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID AND HAOTL.LANGUAGE = USERENV('LANG') AND PAORG.ORGANIZATION_ID = HAO.ORGANIZATION_ID AND PAORG.PA_ORG_USE_TYPE = 'EXPENDITURES' AND PAORG.INACTIVE_DATE IS NULL AND ((mo_global.get_current_org_id is NULL and mo_global.check_access(paorg.org_id) = 'Y') or ( mo_global.get_current_org_id is NOT NULL and paorg.org_id = mo_global.get_current_org_id ))

View Text - HTML Formatted

SELECT HAO.ORGANIZATION_ID
, HAO.BUSINESS_GROUP_ID
, HAOTL.NAME
, HAO.DATE_FROM
, HAO.DATE_TO
, ORG_ID
FROM HR_ALL_ORGANIZATION_UNITS HAO
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
, PA_ALL_ORGANIZATIONS PAORG
WHERE DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HAO.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HAO.BUSINESS_GROUP_ID
AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
AND HAOTL.LANGUAGE = USERENV('LANG')
AND PAORG.ORGANIZATION_ID = HAO.ORGANIZATION_ID
AND PAORG.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND PAORG.INACTIVE_DATE IS NULL
AND ((MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL
AND MO_GLOBAL.CHECK_ACCESS(PAORG.ORG_ID) = 'Y') OR ( MO_GLOBAL.GET_CURRENT_ORG_ID IS NOT NULL
AND PAORG.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID ))