SELECT PAI.ACTION_INFORMATION14 ACTION_INFORMATION14 , COUNT(*) CHECK_COUNT , PAI.ACTION_CONTEXT_ID ACTION_CONTEXT_ID , PAF.PERSON_ID PERSON_ID , PAI.EFFECTIVE_DATE EFFECTIVE_DATE FROM PAY_ACTION_INFORMATION PAI , PAY_ACTION_INFORMATION PAI2 , PER_ALL_ASSIGNMENTS_F PAF , PER_ALL_ASSIGNMENTS_F PAF2 WHERE PAI.ACTION_CONTEXT_ID >= PAI2.ACTION_CONTEXT_ID AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID AND PAI.ACTION_CONTEXT_TYPE = 'AAP' AND PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS' AND PAF2.ASSIGNMENT_ID = PAI2.ASSIGNMENT_ID AND PAI2.ACTION_CONTEXT_TYPE = 'AAP' AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS' AND PAI.EFFECTIVE_DATE = PAI2.EFFECTIVE_DATE AND PAF.PERSON_ID = PAF2.PERSON_ID AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND PAI.EFFECTIVE_DATE BETWEEN PAF2.EFFECTIVE_START_DATE AND PAF2.EFFECTIVE_END_DATE AND EXISTS (SELECT 'X' FROM PAY_ASSIGNMENT_ACTIONS PAA WHERE PAA.ASSIGNMENT_ACTION_ID = PAI.ACTION_CONTEXT_ID AND PAA.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID) AND EXISTS (SELECT 'X' FROM PAY_ASSIGNMENT_ACTIONS PAA2 WHERE PAA2.ASSIGNMENT_ACTION_ID = PAI2.ACTION_CONTEXT_ID AND PAA2.ASSIGNMENT_ID = PAI2.ASSIGNMENT_ID) AND PAY_US_EMPLOYEE_PAYSLIP_WEB.CHECK_EMP_PERSONAL_PAYMENT ( PAF.ASSIGNMENT_ID , PAF.PAYROLL_ID , PAI.ACTION_CONTEXT_ID , PAI.EFFECTIVE_DATE) = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PAY_LEGISLATIVE_FIELD_INFO PLF , HR_ORGANIZATION_INFORMATION HOI , PAY_PAYROLL_ACTIONS PPA , PAY_ASSIGNMENT_ACTIONS PAA WHERE VALIDATION_NAME = 'ITEM_PROPERTY' AND RULE_TYPE = 'PAYSLIP_EMPLOYEE_DETAILS_EXC' AND FIELD_NAME = 'CHOOSE_PAYSLIP' AND LEGISLATION_CODE = HOI.ORG_INFORMATION9 AND ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION' AND ORGANIZATION_ID = PPA.BUSINESS_GROUP_ID AND PPA.REPORT_TYPE = RULE_MODE AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PAA.ASSIGNMENT_ACTION_ID = PAI.ACTION_CONTEXT_ID ) GROUP BY PAI.EFFECTIVE_DATE , PAI.ACTION_CONTEXT_ID , PAI.ACTION_INFORMATION14 , PAF.PERSON_ID