VIEW: APPS.PAYLV_GRE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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