SELECT DISTINCT PPF.PAYROLL_NAME , PPA.PAYROLL_ACTION_ID FROM PAY_PAYROLL_ACTIONS PPA , PAY_ASSIGNMENT_ACTIONS PAA , PER_ASSIGNMENTS_F PAF , PAY_PAYROLLS_F PPF WHERE PPA.ACTION_TYPE = 'H' AND PPA.CHEQUE_REPORT = 'PYZACRED' AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID AND PAF.PAYROLL_ID = PPF.PAYROLL_ID AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE