PER Conclude Placement

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