PQH Annual Status

Description

Imported from BI Publisher
Description: Tenure: Annual Status Report
Application: Public Sector HR
Source: Tenure: Annual Status Report (XML)
Short Name: PQHUSASR_XML
DB package: PQH_PQHUSASR_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

SELECT 	hr.meaning 	Event_accomplishment, 
	pe.date_start
FROM 	per_events 		pe,
	per_bookings		pb,
	per_all_people_f 		pap,
	hr_lookups 		hr
WHERE 	pe.event_id		= pb.event_id 
AND 	pap.person_id		= pb.person_id 
AND 	pe.type 			= hr.lookup_code
AND 	hr.lookup_type 		= 'EMP_EVENT_TYPE'
AND	pe.event_or_interview 	= 'E'
AND	SYSDATE			BETWEEN pap.effective_start_date and pap.effective_end_date
AND 	pe.business_group_id		= :p_business_group_id
AND	pap.person_id		= :p_person_id
AND	UPPER(hr.meaning)	LIKE  '%TENURE%'
UNION
SELECT	title, NVL(awarded_date, NVL(end_date,start_date))
FROM	per_qualifications
WHERE	business_group_id		= :p_business_group_id
AND	person_id			= :p_person_id
ORDER BY 2