View: PAY_AU_ASG_LEAVE_TAKEN_V3

Product:	PAY - Payroll
Description:	Australian localisation view.
Implementation/DBA Data:	APPS.PAY_AU_ASG_LEAVE_TAKEN_V3

View Text

SELECT PAB.ROWID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PTP.TIME_PERIOD_ID TIME_PERIOD_ID
, NVL(PET.REPORTING_NAME
, PET.ELEMENT_NAME) ELEMENT_REPORTING_NAME
, PAB.DATE_START
, PAB.DATE_END
, DECODE(PAT.HOURS_OR_DAYS
, 'H'
, PAB.ABSENCE_HOURS
, PAB.ABSENCE_DAYS)
, /*BUG3887983*/ TO_NUMBER(PRV_P.RESULT_VALUE) PAYMENT
FROM PER_TIME_PERIODS PTP
, PER_ALL_ASSIGNMENTS_F PAA
, /* MODIFIED PER_ASSIGNMENTS_F TO PER_ALL_ASSIGNMENTS_F BUG 4731967 */ PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_RUN_RESULTS PRR
, PAY_RUN_RESULT_VALUES PRV_P
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV_A
, PAY_INPUT_VALUES_F PIV_P
, PER_ABSENCE_ATTENDANCE_TYPES PAT
, PER_ABSENCE_ATTENDANCES PAB
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_ENTRY_VALUES_F PEV
, PAY_INPUT_VALUES_F PIV_I3
, PAY_ELEMENT_ENTRY_VALUES_F PEEV1
WHERE PTP.PAYROLL_ID = PPA.PAYROLL_ID
AND PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PAC.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAC.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID /* ADDED FOR BUG#2665475 */
AND PEE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID /* ADDED FOR BUG 4731967 */
AND PEE.EFFECTIVE_START_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE /* ADDED FOR BUG 4731967 */
AND PEE.EFFECTIVE_END_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE /* ADDED FOR BUG 4731967 */
AND PAC.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID /* ADDED FOR BUG 4731967 */
AND PPA.DATE_EARNED BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND PAT.ABSENCE_ATTENDANCE_TYPE_ID = PAB.ABSENCE_ATTENDANCE_TYPE_ID
AND PIV_A.INPUT_VALUE_ID = PAT.INPUT_VALUE_ID
AND PET.ELEMENT_TYPE_ID = PIV_A.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PIV_P.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID
AND PRR.RUN_RESULT_ID = PRV_P.RUN_RESULT_ID
AND PIV_P.INPUT_VALUE_ID = PRV_P.INPUT_VALUE_ID
AND PIV_P.NAME = 'PAY VALUE'
AND PAB.ABSENCE_ATTENDANCE_ID = PEE.CREATOR_ID
AND PEE.CREATOR_TYPE = 'A'
AND PEE.ELEMENT_ENTRY_ID = PEV.ELEMENT_ENTRY_ID
AND PEV.INPUT_VALUE_ID = PIV_P.INPUT_VALUE_ID
AND PRR.SOURCE_ID = PEE.ELEMENT_ENTRY_ID
AND PIV_I3.NAME(+) = 'PAY DATE'
AND PIV_I3.ELEMENT_TYPE_ID(+) = PET.ELEMENT_TYPE_ID
AND PEE.ELEMENT_ENTRY_ID = PEEV1.ELEMENT_ENTRY_ID
AND ( ( PEEV1.INPUT_VALUE_ID = PIV_I3.INPUT_VALUE_ID
AND NVL(TO_DATE(PEEV1.SCREEN_ENTRY_VALUE
, 'YYYY/MM/DD HH24:MI:SS')
, PTP.START_DATE) BETWEEN PTP.START_DATE
AND PTP.END_DATE) OR (PIV_I3.INPUT_VALUE_ID IS NULL))

Columns