View: PAY_ZA_ASSIGNMENT_ACTIONS_V

Product:	PAY - Payroll
Description:	PAY_ZA_ASSIGNMENT_ACTIONS_V gives you a list of credit transfer cheque numbers and associated payroll action id's that was issued.
Implementation/DBA Data:	APPS.PAY_ZA_ASSIGNMENT_ACTIONS_V

View Text

SELECT DISTINCT PAA.SERIAL_NUMBER
, PAA.PAYROLL_ACTION_ID
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.ACTION_TYPE = 'H'
AND PPA.CHEQUE_REPORT = 'PYZACRED'
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND SERIAL_NUMBER IS NOT NULL

Columns