View: PAY_IE_PAYMENT_VALUES_V

Product:	PAY - Payroll
Description:	Used in IE Payslip Advice Report in PAY_IE_EAR_DED_V View
Implementation/DBA Data:	APPS.PAY_IE_PAYMENT_VALUES_V

View Text

SELECT PET.ROWID ROW_ID
, PET.ELEMENT_TYPE_ID
, PIV.INPUT_VALUE_ID
, DECODE(PET.ELEMENT_NAME
, 'IE BIK ARREARAGE DETAILS'
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PRV.RESULT_VALUE))*(-1)
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PRV.RESULT_VALUE))) RESULT_VALUE
, PET.PROCESSING_PRIORITY
, PAC.LOCKING_ACTION_ID ASSIGNMENT_ACTION_ID
FROM PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULT_VALUES PRV
, PAY_RUN_RESULTS PRR
, PAY_ACTION_INTERLOCKS PAC
, FND_SESSIONS SES
WHERE PRR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.STATUS IN ('P'
, 'PA')
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 SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND ( (PIV.NAME ='PAY VALUE'
AND PIV.UOM = 'M') OR (PET.ELEMENT_NAME IN ('IE BIK ARREARAGE DETAILS'
, 'IE BIK ARREARAGE RECOVERY DETAILS')
AND PIV.NAME IN ('BIK ARREARAGE'
, 'BIK ARREARAGE RECOVERED')) OR (PET.ELEMENT_NAME IN ('IE BIK ACCOMMODATION DETAILS'
, 'IE BIK ASSET TYPE DETAILS'
, 'IE BIK COMPANY VEHICLE DETAILS'
, 'IE BIK PREFERENTIAL LOAN DETAILS'
, 'IE BIK OTHER REPORTABLE ITEM DETAILS')
AND PIV.NAME = ('TAXABLE VALUE FOR RUN')) OR (PET.ELEMENT_NAME IN ('IE BIK NON RECURRING REPORTABLE ITEMS')
AND PIV.NAME ='BENEFIT VALUE') OR (PET.ELEMENT_NAME IN ('IE PAYE AT HIGHER RATE'
, 'IE PAYE AT STANDARD RATE')
AND PIV.NAME ='VALUE' ))
AND PET.ELEMENT_NAME NOT IN ('IE NET TAX')
AND PAC.LOCKED_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID GROUP BY PAC.LOCKING_ACTION_ID
, PET.PROCESSING_PRIORITY
, PET.ELEMENT_TYPE_ID
, PET.ELEMENT_NAME
, PIV.INPUT_VALUE_ID
, DECODE(PET.ELEMENT_NAME
, 'IE BIK ACCOMMODATION DETAILS'
, DECODE(PIV.NAME
, 'TAXABLE VALUE FOR RUN'
, PRR.RUN_RESULT_ID)
, 'IE BIK ASSET TYPE DETAILS'
, DECODE(PIV.NAME
, 'TAXABLE VALUE FOR RUN'
, PRR.RUN_RESULT_ID)
, 'IE BIK COMPANY VEHICLE DETAILS'
, DECODE(PIV.NAME
, 'TAXABLE VALUE FOR RUN'
, PRR.RUN_RESULT_ID)
, 'IE BIK PREFERENTIAL LOAN DETAILS'
, DECODE(PIV.NAME
, 'TAXABLE VALUE FOR RUN'
, PRR.RUN_RESULT_ID)
, 'IE BIK OTHER REPORTABLE ITEM DETAILS'
, DECODE(PIV.NAME
, 'TAXABLE VALUE FOR RUN'
, PRR.RUN_RESULT_ID)
, 'IE BIK NON RECURRING REPORTABLE ITEMS'
, DECODE(PIV.NAME
, 'BENEFIT VALUE'
, PRR.RUN_RESULT_ID)
, NULL)
, PET.ROWID

Columns