PER Terminations

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Terminations Report
Application: Human Resources
Source: Terminations Report (XML)
Short Name: PERRPRTM_XML
DB package: PER_PERRPRTM_XMLP_PKG
Run PER Terminations and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT A.ORGANIZATION_ID ORGANIZATION_ID1,
	count(distinct
		decode(:P_LEAV_REASON1,null,null, &P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason1_tot,
	count(distinct
		decode(:P_LEAV_REASON2,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason2_tot,
	count(distinct
		decode(:P_LEAV_REASON3,null,null, &P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason3_tot,
	count(distinct
		decode(:P_LEAV_REASON4,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason4_tot,
	count(distinct
		decode(:P_LEAV_REASON5,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason5_tot,
	count(distinct
		decode(:P_LEAV_REASON6,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason6_tot,
           count(distinct
                   decode(&P_REASON_COLUMN,
                        decode(:P_LEAV_REASON1,null,'999',:P_LEAV_REASON1),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON2,null,'999',:P_LEAV_REASON2),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON3,null,'999',:P_LEAV_REASON3),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON4,null,'999',:P_LEAV_REASON4),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON5,null,'999',:P_LEAV_REASON5),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON5,null,'999',:P_LEAV_REASON5),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                                              null)) reasons_tot,
            count(distinct P.PERSON_ID||P.ACTUAL_TERMINATION_DATE) all_total
FROM   PER_PERIODS_OF_SERVICE P,
	PER_ASSIGNMENTS_F A
WHERE  P.PERIOD_OF_SERVICE_ID = A.PERIOD_OF_SERVICE_ID
	AND  A.ASSIGNMENT_TYPE = 'E'
	AND  P.ACTUAL_TERMINATION_DATE BETWEEN
		A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE
	AND  P.ACTUAL_TERMINATION_DATE BETWEEN
		:P_DATE_FROM AND :P_DATE_TO
 and A.ORGANIZATION_ID=:org_id
group by A.ORGANIZATION_ID
Parameter Name SQL text Validation
Effective Date 
 
 Date
Organization Structure 
 
 LOV Oracle
Version 
 
 LOV Oracle
Parent Organization 
 
 LOV Oracle
Date From 
 
 Date
Date To 
 
 Date
Termination Reason 1 
 
 LOV Oracle
Termination Reason 2 
 
 LOV Oracle
Termination Reason 3 
 
 LOV Oracle
Termination Reason 4 
 
 LOV Oracle
Termination Reason 5 
 
 LOV Oracle
Termination Reason 6 
 
 LOV Oracle
Download
Related Blitz Reports
AP Employee Update Program- Not Supported: Reserved For Future Use SSP Statutory Sick Pay PER Worker Organization Movements ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets RKD Employee Element History PAY End of Year Reconciliation Summary Totals PQH EEO5 Reporting BEN Back-out Life Events Summary BEN Back-out Life Events Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: