PQH EEO4 Reporting

SELECT 	org_information1	Cert_Officer_Name,
	org_information2	Cert_Official_Title,
	org_information3	Contact_Name,
	org_information4	Contact_Title,
	org_information5||' '||
	org_information6	Contact_Address,
	org_information7||' '||
	org_information8||' '||
	org_information9	Contact_City_State_Zip,
	org_information10	Contact_Telephone,
	org_information12	Control_number
FROM	hr_organization_information
WHERE	org_information_context	= 'EEO_REPORT'
AND	organization_id		= :p_business_group_id
AND	org_information11		= 'EEO4'

SELECT org_information1 Cert_Officer_Name, org_information2 Cert_Official_Title, org_information3 Contact_Name, org_information4 Contact_Title, org_information5||' '|| org_information6 Contact_Address, org_information7||' '|| org_information8||' '|| org_information9 Contact_City_State_Zip, org_information10 Contact_Telephone, org_information12 Control_number FROM hr_organization_information WHERE org_information_context = 'EEO_REPORT' AND organization_id = :p_business_group_id AND org_information11 = 'EEO4'