View: PAY_NZ_ASG_PAYMENT_RUNS_V

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

View Text

SELECT DISTINCT PAA.ROWID ROW_ID
, OU.BUSINESS_GROUP_ID
, PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PER.PERSON_ID
, PAY_NZ_SOE_PKG.GET_SALARY(ASF.PAY_BASIS_ID
, ASF.ASSIGNMENT_ID
, RPPA.DATE_EARNED) SALARY
, PAY_NZ_SOE_PKG.GET_TAX_CODE(RPAA.ASSIGNMENT_ACTION_ID) TAX_CODE
, PCAK.CONCATENATED_SEGMENTS COST_CENTRE
, NVL(PCAF.PROPORTION
, 0) * 100 COST_CENTRE_PROPORTION
, POS.NAME POSITION_TITLE
, PER.FULL_NAME
, PER.ORDER_NAME
, PER.TITLE
, SUBSTR(PER.FIRST_NAME
, 1
, 1)||' '||SUBSTR(PER.MIDDLE_NAMES
, 1
, 1) INITIALS
, PER.LAST_NAME
, ASF.ASSIGNMENT_NUMBER
, OU.NAME REGISTERED_EMPLOYER
, HL.LOCATION_ID LOCATION_ID
, HL.LOCATION_CODE LOCATION_CODE
, ASF.INTERNAL_ADDRESS_LINE
, PER.NATIONAL_IDENTIFIER IRD_NUMBER
, PER.EXPENSE_CHECK_SEND_TO_ADDRESS
, RPPA.DATE_EARNED DATE_EARNED
, PAA.PAYROLL_ACTION_ID
, RPAA.ASSIGNMENT_ACTION_ID RUN_ASSIGNMENT_ACTION_ID
, RPAA.PAYROLL_ACTION_ID RUN_PAYROLL_ACTION_ID
, PTP.TIME_PERIOD_ID TIME_PERIOD_ID
, PTP.PERIOD_NUM PERIOD_NUMBER
, PTP.START_DATE PERIOD_START_DATE
, PTP.END_DATE PERIOD_END_DATE
, RPPA.PAYROLL_ID PAYROLL_ID
, NVL(RPPA.PAY_ADVICE_DATE
, PTP.PAY_ADVICE_DATE) PAY_ADVICE_DATE
, PPG.SEGMENT1
, PPG.SEGMENT2
, PPG.SEGMENT3
, PPG.SEGMENT4
, PPG.SEGMENT5
, PPG.SEGMENT6
, PPG.SEGMENT7
, PPG.SEGMENT8
, PPG.SEGMENT9
, PPG.SEGMENT10
, PPG.SEGMENT11
, PPG.SEGMENT12
, PPG.SEGMENT13
, PPG.SEGMENT14
, PPG.SEGMENT15
, PPG.SEGMENT16
, PPG.SEGMENT17
, PPG.SEGMENT18
, PPG.SEGMENT19
, PPG.SEGMENT20
, PPG.SEGMENT21
, PPG.SEGMENT22
, PPG.SEGMENT23
, PPG.SEGMENT24
, PPG.SEGMENT25
, PPG.SEGMENT26
, PPG.SEGMENT27
, PPG.SEGMENT28
, PPG.SEGMENT29
, PPG.SEGMENT30
FROM HR_LOCATIONS HL
, PER_POSITIONS POS
, PER_ASSIGNMENTS_F ASF
, PER_PEOPLE_F PER
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS RPAA
, PAY_PAYROLL_ACTIONS RPPA
, PAY_ACTION_INTERLOCKS IL
, PER_TIME_PERIODS PTP
, PAY_COST_ALLOCATION_KEYFLEX PCAK
, PAY_COST_ALLOCATIONS_F PCAF
, PAY_PEOPLE_GROUPS PPG
, HR_SOFT_CODING_KEYFLEX SCL
, HR_ORGANIZATION_UNITS OU
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('U'
, 'P')
AND PPA.ACTION_STATUS = 'C'
AND PAA.ACTION_STATUS = 'C'
AND PPA.PAYROLL_ID = RPPA.PAYROLL_ID
AND PPA.EFFECTIVE_DATE >= RPPA.EFFECTIVE_DATE
AND RPAA.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PCAF.COST_ALLOCATION_KEYFLEX_ID = PCAK.COST_ALLOCATION_KEYFLEX_ID(+)
AND PCAF.ASSIGNMENT_ID(+) = PAA.ASSIGNMENT_ID
AND HL.LOCATION_ID(+) = ASF.LOCATION_ID
AND PPG.PEOPLE_GROUP_ID(+) = ASF.PEOPLE_GROUP_ID
AND POS.POSITION_ID (+) = ASF.POSITION_ID
AND PER.PERSON_ID = ASF.PERSON_ID
AND PAA.ASSIGNMENT_ID = ASF.ASSIGNMENT_ID
AND RPPA.DATE_EARNED BETWEEN ASF.EFFECTIVE_START_DATE
AND ASF.EFFECTIVE_END_DATE
AND RPPA.PAYROLL_ID = PTP.PAYROLL_ID
AND RPPA.DATE_EARNED BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND RPPA.DATE_EARNED BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND RPPA.PAYROLL_ACTION_ID = RPAA.PAYROLL_ACTION_ID
AND RPAA.ASSIGNMENT_ACTION_ID = IL.LOCKED_ACTION_ID
AND PAA.ASSIGNMENT_ACTION_ID = IL.LOCKING_ACTION_ID
AND IL.ROWID = (SELECT SUBSTR(MAX(LPAD(AA.ACTION_SEQUENCE
, 15
, 0)||LOC.ROWID)
, -18) LATEST_ACT
FROM PAY_ASSIGNMENT_ACTIONS AA
, PAY_ACTION_INTERLOCKS LOC
WHERE LOC.LOCKED_ACTION_ID = AA.ASSIGNMENT_ACTION_ID
AND LOC.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID)
AND SCL.SOFT_CODING_KEYFLEX_ID = ASF.SOFT_CODING_KEYFLEX_ID
AND TO_NUMBER(SCL.SEGMENT1) = OU.ORGANIZATION_ID

Columns