View: PAY_HK_IR56_EMOLUMENTS_V

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

View Text

SELECT PTP.START_DATE
, PTP.END_DATE
, NVL(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.RESULT_VALUE)
, 0) * FEED.SCALE
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, BAL_ASSACT.ASSIGNMENT_ACTION_ID
, BAL_ASSACT.ACTION_SEQUENCE
, BAL_ASSACT.ASSIGNMENT_ID
, ASSACT.TAX_UNIT_ID
, PETF.INPUT_CURRENCY_CODE
FROM PAY_RUN_RESULT_VALUES TARGET
, PAY_BALANCE_FEEDS_F FEED
, PAY_RUN_RESULTS RR
, PAY_ASSIGNMENT_ACTIONS ASSACT
, PAY_ASSIGNMENT_ACTIONS BAL_ASSACT
, PAY_PAYROLL_ACTIONS PACT
, PAY_PAYROLL_ACTIONS BACT
, PER_TIME_PERIODS PTP
, PAY_BALANCE_TYPES PBT
, PAY_INPUT_VALUES_F PIVF
, PAY_ELEMENT_TYPES_F PETF
WHERE BAL_ASSACT.PAYROLL_ACTION_ID = BACT.PAYROLL_ACTION_ID
AND FEED.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID + DECODE(TARGET.INPUT_VALUE_ID
, NULL
, 0
, 0)
AND FEED.INPUT_VALUE_ID = TARGET.INPUT_VALUE_ID
AND NVL(TARGET.RESULT_VALUE
, '0') <> '0'
AND TARGET.RUN_RESULT_ID = RR.RUN_RESULT_ID
AND RR.ASSIGNMENT_ACTION_ID = ASSACT.ASSIGNMENT_ACTION_ID
AND ASSACT.PAYROLL_ACTION_ID = PACT.PAYROLL_ACTION_ID
AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
AND PACT.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE
AND FEED.EFFECTIVE_END_DATE
AND RR.STATUS IN ('P'
, 'PA')
AND ASSACT.ACTION_SEQUENCE <= BAL_ASSACT.ACTION_SEQUENCE
AND ASSACT.ASSIGNMENT_ID = BAL_ASSACT.ASSIGNMENT_ID
AND PACT.EFFECTIVE_DATE >= (TO_DATE('01-04-'||TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER( TO_CHAR(BACT.EFFECTIVE_DATE
, 'YYYY')) + DECODE( SIGN(BACT.EFFECTIVE_DATE - TO_DATE('01-04-'||TO_CHAR(BACT.EFFECTIVE_DATE
, 'YYYY')
, 'DD-MM-YYYY'))
, -1
, -1
, 0))
, 'DD-MM-YYYY'))
AND PTP.TIME_PERIOD_ID = PACT.TIME_PERIOD_ID
AND ASSACT.ASSIGNMENT_ID = BAL_ASSACT.ASSIGNMENT_ID
AND PIVF.INPUT_VALUE_ID = FEED.INPUT_VALUE_ID
AND PETF.ELEMENT_TYPE_ID = PIVF.ELEMENT_TYPE_ID

Columns