View: PAY_SG_ASG_ACTIONS_V

Product:	PAY - Payroll
Description:	Singapore localisation view.
Implementation/DBA Data:	APPS.PAY_SG_ASG_ACTIONS_V

View Text

SELECT DISTINCT RPAC.ROWID ROW_ID
, HOU.BUSINESS_GROUP_ID
, HAOU.NAME ORGANIZATION_NAME
, HOI.ORG_INFORMATION9 LEGISLATION_CODE
, PAY_SG_SOE.GET_PAYROLL_CURRENCY_CODE(PAY.PAYROLL_ID
, RPPA.EFFECTIVE_DATE)
, PAP.PERSON_ID
, PAP.FULL_NAME
, PAP.EMPLOYEE_NUMBER
, PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, HLO.LOCATION_ID
, HLO.LOCATION_CODE
, PAY_SG_SOE.CURRENT_SALARY (PAA.PAY_BASIS_ID
, PAA.ASSIGNMENT_ID
, RPPA.DATE_EARNED) SALARY
, PAY.PAYROLL_ID
, PAY.PAYROLL_NAME
, PTP.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PTP.START_DATE PERIOD_START_DATE
, PTP.END_DATE PERIOD_END_DATE
, PTP.REGULAR_PAYMENT_DATE
, RPPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, RPAC.ASSIGNMENT_ACTION_ID RUN_ASSIGNMENT_ACTION_ID
, RPPA.DATE_EARNED
, PPPA.PAYROLL_ACTION_ID PREPAY_PAYROLL_ACTION_ID
, DECODE(PPPA.ACTION_TYPE
, 'V'
, NULL
, PPAC.ASSIGNMENT_ACTION_ID) PREPAY_ASSIGNMENT_ACTION_ID
, NVL(PPAC.ASSIGNMENT_ACTION_ID
, RPAC.ASSIGNMENT_ACTION_ID)
, DECODE(PPPA.ACTION_TYPE
, 'C'
, 0
, 1) COST
FROM PAY_ALL_PAYROLLS_F PAY
, PAY_PAYROLL_ACTIONS RPPA
, PAY_PAYROLL_ACTIONS PPPA
, PAY_ASSIGNMENT_ACTIONS RPAC
, PAY_ACTION_INTERLOCKS PAI
, PAY_ASSIGNMENT_ACTIONS PPAC
, PER_ALL_ASSIGNMENTS_F PAA
, PER_ALL_PEOPLE_F PAP
, HR_LOCATIONS HLO
, PER_TIME_PERIODS PTP
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HAOU
, HR_ORGANIZATION_INFORMATION HOI
WHERE HOI.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION'
AND RPPA.ACTION_TYPE IN ('R'
, 'Q')
AND RPPA.ACTION_STATUS = 'C'
AND RPPA.PAYROLL_ACTION_ID = RPAC.PAYROLL_ACTION_ID
AND PAI.LOCKED_ACTION_ID(+) = RPAC.ASSIGNMENT_ACTION_ID
AND PAI.LOCKING_ACTION_ID = PPAC.ASSIGNMENT_ACTION_ID(+)
AND PPAC.PAYROLL_ACTION_ID = PPPA.PAYROLL_ACTION_ID(+)
AND NVL(PPPA.ACTION_TYPE
, 'P') IN ('P'
, 'U'
, 'C'
, 'V')
AND NVL(PPPA.ACTION_STATUS
, 'C') = 'C'
AND RPPA.EFFECTIVE_DATE <= NVL(PPPA.EFFECTIVE_DATE
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))
AND PAY.PAYROLL_ID = RPPA.PAYROLL_ID
AND PAY.PAYROLL_ID = PAA.PAYROLL_ID
AND PAA.ASSIGNMENT_ID = RPAC.ASSIGNMENT_ID
AND RPPA.DATE_EARNED BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE
AND PAP.PERSON_ID = PAA.PERSON_ID
AND RPPA.DATE_EARNED BETWEEN PAP.EFFECTIVE_START_DATE
AND PAP.EFFECTIVE_END_DATE
AND HLO.LOCATION_ID(+) = PAA.LOCATION_ID
AND HOU.ORGANIZATION_ID = PAA.BUSINESS_GROUP_ID
AND HAOU.ORGANIZATION_ID = PAA.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION9 = 'SG'
AND PAY.PAYROLL_ID = PTP.PAYROLL_ID
AND PTP.TIME_PERIOD_ID = RPPA.TIME_PERIOD_ID ORDER BY COST DESC

Columns