PQH Annual Status

➜ Back to Library
Description
Categories: BI Publisher
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
Run PQH Annual Status and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Faculty Member 
 
 LOV Oracle
Download
Related Blitz Reports
PQH Upcoming Events OTA Learner Sign-In Sheet OTA Registration OTA Attendance Signature Sheet OTA Budget Costs Breakdown PQH Notification for Tenure-track Status GL Account Analysis GL Account Analysis (Distributions) PQH IPEDS Report - Employees By Assigned Position (EAP) - Part A(obsoleted)
Blitz Report™

Blitz Report™ provides multiple benefits: