View: PAY_HK_ASG_PAYMENT_RUNS_V

Product:	PAY - Payroll
Description:	Hong Kong localisation view.
Implementation/DBA Data:	APPS.PAY_HK_ASG_PAYMENT_RUNS_V

View Text

SELECT PAI.ROWID ROW_ID
, PAAF.ASSIGNMENT_ID ASSIGNMENT_ID
, PAAF.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PAAF.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HAOU.NAME BUSINESS_GROUP_NAME
, PPF.PER_INFORMATION6 FULL_NAME
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, HL.LOCATION_CODE LOCATION_CODE
, PPF.MAILSTOP MAILSTOP
, HAOU2.NAME ORGANIZATION_NAME
, PPA.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, PPA.PAYROLL_ID PAYROLL_ID
, PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA2.TAX_UNIT_ID TAX_UNIT_ID
, NVL(PPA2.PAY_ADVICE_DATE
, PTP.PAY_ADVICE_DATE) PAY_ADVICE_DATE
, PPA2.EFFECTIVE_DATE PAYMENT_DATE
, PPA2.DATE_EARNED DATE_EARNED
, PTP.START_DATE PERIOD_START_DATE
, PTP.END_DATE PERIOD_END_DATE
FROM PER_ASSIGNMENTS_F PAAF
, PER_PEOPLE_F PPF
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ACTION_INTERLOCKS PAI
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA2
, PER_TIME_PERIODS PTP
, HR_ORGANIZATION_UNITS HAOU
, HR_LOCATIONS HL
, HR_ORGANIZATION_UNITS HAOU2
WHERE PAAF.PERSON_ID = PPF.PERSON_ID
AND PAAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND 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 PAI.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA2.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND PPA2.DATE_EARNED BETWEEN PAAF.EFFECTIVE_START_DATE
AND PAAF.EFFECTIVE_END_DATE
AND PPA2.DATE_EARNED BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PAA.ASSIGNMENT_ID = PAA2.ASSIGNMENT_ID
AND PPA.EFFECTIVE_DATE >= PPA2.EFFECTIVE_DATE
AND HAOU.ORGANIZATION_ID = PAAF.BUSINESS_GROUP_ID
AND HL.LOCATION_ID (+) = PAAF.LOCATION_ID
AND HAOU2.ORGANIZATION_ID = PAAF.ORGANIZATION_ID
AND PAI.ROWID = (SELECT SUBSTR(MAX(LPAD(PAA_LOCKED.ACTION_SEQUENCE
, 15
, 0) ||PAI_LOCKED.ROWID)
, -18) LATEST_ACT
FROM PAY_ASSIGNMENT_ACTIONS PAA_LOCKED
, PAY_ACTION_INTERLOCKS PAI_LOCKED
WHERE PAI_LOCKED.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAI_LOCKED.LOCKED_ACTION_ID = PAA_LOCKED.ASSIGNMENT_ACTION_ID)

Columns