VIEW: APPS.PA_ORGANIZATIONS_EXPEND_V

Source

View Text - Preformatted

SELECT hrorg.organization_id , hrorg.business_group_id , hrorg.name , hrorg.date_from , hrorg.date_to , 'Y' ,org_id from hr_organization_units hrorg, pa_all_organizations paorg WHERE paorg.organization_id = hrorg.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 HRORG.ORGANIZATION_ID
, HRORG.BUSINESS_GROUP_ID
, HRORG.NAME
, HRORG.DATE_FROM
, HRORG.DATE_TO
, 'Y'
, ORG_ID
FROM HR_ORGANIZATION_UNITS HRORG
, PA_ALL_ORGANIZATIONS PAORG
WHERE PAORG.ORGANIZATION_ID = HRORG.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 ))