View: PAYLV_GRE_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYLV_GRE_V

View Text

SELECT O.ORGANIZATION_ID
, O.NAME
, CASE WHEN O.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, O.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, O.NAME ORDER_BY
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
WHERE O3.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_LEGAL'
AND O2.ORG_INFORMATION_CONTEXT(+) = 'EMPLOYER IDENTIFICATION'
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID(+)
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O3.ORG_INFORMATION2 = 'Y' UNION ALL SELECT -1
, NULL
, 'Y'
, ' ' ORDER_BY
FROM DUAL

Columns