PER Conclude Placement

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Conclude Placement Report
Application: Human Resources
Source: Conclude Placement Report (XML)
Short Name: PERRPCTM_XML
DB package: PER_PERRPCTM_XMLP_PKG
SELECT PAF.ORGANIZATION_ID,
	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_PLACEMENT P,
       PER_PEOPLE_F PAP,
       PER_ASSIGNMENTS_F PAF
WHERE  P.ACTUAL_TERMINATION_DATE BETWEEN :P_DATE_FROM
                                     AND :P_DATE_TO
AND    P.ACTUAL_TERMINATION_DATE BETWEEN PAP.EFFECTIVE_START_DATE
                                     AND PAP.EFFECTIVE_END_DATE
AND    PAP.PERSON_ID = P.PERSON_ID
AND    PAF.PERSON_ID = P.PERSON_ID
AND    P.ACTUAL_TERMINATION_DATE BETWEEN PAF.EFFECTIVE_START_DATE
                                     AND PAF.EFFECTIVE_END_DATE
AND    PAF.ASSIGNMENT_TYPE = 'C'
 and PAF.ORGANIZATION_ID=:org_id
GROUP by Organization_Id
Parameter NameSQL textValidation
Effective Date
 
Date
Organization Structure
 
LOV Oracle
Version
 
LOV Oracle
Parent Organization
 
LOV Oracle
Date From
 
Date
Date To
 
Date
Conclude Reason 1
 
LOV Oracle
Conclude Reason 2
 
LOV Oracle
Conclude Reason 3
 
LOV Oracle
Conclude Reason 4
 
LOV Oracle
Conclude Reason 5
 
LOV Oracle
Conclude Reason 6
 
LOV Oracle
Download
Related Blitz Reports
PER Worker Organization Movements SSP Statutory Shared Parental Adoption Pay SSP Statutory Paternity Adoption Pay SSP Statutory Adoption Pay AP Employee Update Program- Not Supported: Reserved For Future Use PER Payroll Element Entry Upload BEN Back-out Life Events Summary BEN Back-out Life Events Audit Log TB GL Account Analysis (Drilldown)v2
Blitz Report™