View: PAY_NZ_ASG_LEAVE_TAKEN_V2

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_NZ_ASG_LEAVE_TAKEN_V2

View Text

SELECT PAB.ROWID
, PAC.ASSIGNMENT_ID ASSIGNMENT_ID
, PTP.TIME_PERIOD_ID TIME_PERIOD_ID
, NVL(PET1.REPORTING_NAME
, PET1.ELEMENT_NAME) ELEMENT_REPORTING_NAME
, PAB.DATE_START
, PAB.DATE_END
, SUM(DECODE(PET1.PROCESSING_TYPE
, 'R'
, TO_NUMBER(PRRV1.RESULT_VALUE)
, DECODE(PAT.HOURS_OR_DAYS
, 'D'
, PAB.ABSENCE_DAYS
, PAB.ABSENCE_HOURS))) ABSENCE_DURATION
, SUM(TO_NUMBER(PRRV2.RESULT_VALUE)) PAYMENT
, PPA.DATE_EARNED
FROM PER_TIME_PERIODS PTP
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_RUN_RESULTS PRR
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ASSIGNMENT_ACTIONS PAC1
, PAY_RUN_RESULTS PRR1
, PAY_ELEMENT_ENTRIES_F PEE1
, PAY_ELEMENT_TYPES_F PET1
, PER_ABSENCE_ATTENDANCES PAB
, PER_ABSENCE_ATTENDANCE_TYPES PAT
, PAY_RUN_RESULT_VALUES PRRV1
, PAY_INPUT_VALUES_F PIV1
, PAY_RUN_RESULT_VALUES PRRV2
, PAY_INPUT_VALUES_F PIV2
WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PAC.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
AND PTP.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID
AND PPA.DATE_EARNED BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND PRR.SOURCE_ID = PEE.ELEMENT_ENTRY_ID
AND PEE.CREATOR_TYPE IN ('RR'
, 'EE')
AND PRR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRR.RUN_RESULT_ID = PRRV1.RUN_RESULT_ID
AND PRRV1.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND PRR.ELEMENT_TYPE_ID = PIV1.ELEMENT_TYPE_ID
AND PIV1.NAME = 'LEAVE TAKEN'
AND PRR.RUN_RESULT_ID = PRRV2.RUN_RESULT_ID
AND PRRV2.INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID
AND PRR.ELEMENT_TYPE_ID = PIV2.ELEMENT_TYPE_ID
AND PIV2.NAME = 'PAY VALUE'
AND PEE.SOURCE_ASG_ACTION_ID = PAC1.ASSIGNMENT_ACTION_ID
AND PAC1.ASSIGNMENT_ACTION_ID = PRR1.ASSIGNMENT_ACTION_ID
AND PRR1.ELEMENT_ENTRY_ID = PEE1.ELEMENT_ENTRY_ID
AND PEE1.ELEMENT_TYPE_ID = PET1.ELEMENT_TYPE_ID
AND PEE1.CREATOR_TYPE = 'A'
AND PAB.ABSENCE_ATTENDANCE_ID = PEE1.CREATOR_ID
AND PAT.ABSENCE_ATTENDANCE_TYPE_ID = PAB.ABSENCE_ATTENDANCE_TYPE_ID
AND PPA.DATE_EARNED BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PPA.DATE_EARNED BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE GROUP BY PAB.ROWID
, PAC.ASSIGNMENT_ID
, PTP.TIME_PERIOD_ID
, NVL(PET1.REPORTING_NAME
, PET1.ELEMENT_NAME)
, PAB.DATE_START
, PAB.DATE_END
, PPA.DATE_EARNED

Columns