View: PAY_NZ_ASG_ELEMENT_PAYMENTS_V

Product:	PAY - Payroll
Description:	New Zealand localisation view.
Implementation/DBA Data:	APPS.PAY_NZ_ASG_ELEMENT_PAYMENTS_V

View Text

SELECT PET.ROWID ROW_ID
, NVL(PET.REPORTING_NAME
, PET.ELEMENT_NAME) REPORT_NAME
, DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'EARNINGS')
, 0
, NULL
, 'TAXABLE EARNINGS') || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'REIMBURSEMENTS')
, 0
, NULL
, 'NON TAXABLE ALLOWANCES') || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'DEDUCTIONS')
, 0
, NULL
, 'DEDUCTIONS') || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'INFORMATION')
, 0
, NULL
, DECODE(PET.ELEMENT_NAME
, 'EMPLOYER SUPER CONTRIBUTIONS'
, 'EMPLOYER SUPERANNUATION CONTRIBUTIONS'
, NULL)) || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'EMPLOYER CHARGES')
, 0
, NULL
, DECODE(PET.ELEMENT_NAME
, 'SSCWT DEDUCTION'
, 'EMPLOYER SUPERANNUATION CONTRIBUTIONS'
, NULL)) CLASSIFICATION_NAME
, SUM(PRV.RESULT_VALUE) RESULT_VALUE
, PET.PROCESSING_PRIORITY
, PAAP.ASSIGNMENT_ACTION_ID
FROM PAY_ELEMENT_TYPES_F PET
, PER_ASSIGNMENTS_F PAA
, PAY_ACTION_INTERLOCKS PAI
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULT_VALUES PRV
, PAY_RUN_RESULTS PRR
, PAY_ASSIGNMENT_ACTIONS PAAP
, PAY_PAYROLL_ACTIONS PAP
WHERE PRR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.STATUS IN ('P'
, 'PA')
AND PAP.ACTION_TYPE IN('P'
, 'U')
AND PAI.LOCKING_ACTION_ID = PAAP.ASSIGNMENT_ACTION_ID
AND PAI.LOCKED_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND (PEC.LEGISLATION_CODE IS NULL OR PEC.LEGISLATION_CODE = 'NZ')
AND PET.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
AND (INSTR(PEC.CLASSIFICATION_NAME
, 'EARNINGS') > 0 OR INSTR(PEC.CLASSIFICATION_NAME
, 'REIMBURSEMENTS') > 0 OR INSTR(PEC.CLASSIFICATION_NAME
, 'DEDUCTIONS') > 0 OR INSTR(PEC.CLASSIFICATION_NAME
, 'EMPLOYER CHARGES')>0 OR INSTR(PEC.CLASSIFICATION_NAME
, 'INFORMATION')> 0)
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND PIV.NAME = 'PAY VALUE'
AND PIV.UOM = 'M'
AND PAAP.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAP.PAYROLL_ACTION_ID = PAAP.PAYROLL_ACTION_ID
AND PAP.EFFECTIVE_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE
AND PAP.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE GROUP BY PAAP.ASSIGNMENT_ACTION_ID
, PET.PROCESSING_PRIORITY
, DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'EARNINGS')
, 0
, NULL
, 'TAXABLE EARNINGS') || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'REIMBURSEMENTS')
, 0
, NULL
, 'NON TAXABLE ALLOWANCES') || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'DEDUCTIONS')
, 0
, NULL
, 'DEDUCTIONS') || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'INFORMATION')
, 0
, NULL
, DECODE(PET.ELEMENT_NAME
, 'EMPLOYER SUPER CONTRIBUTIONS'
, 'EMPLOYER SUPERANNUATION CONTRIBUTIONS'
, NULL)) || DECODE(INSTR(PEC.CLASSIFICATION_NAME
, 'EMPLOYER CHARGES')
, 0
, NULL
, DECODE(PET.ELEMENT_NAME
, 'SSCWT DEDUCTION'
, 'EMPLOYER SUPERANNUATION CONTRIBUTIONS'
, NULL))
, NVL(PET.REPORTING_NAME
, PET.ELEMENT_NAME)
, PET.ROWID

Columns