[Home] [Help]
View: PAY_HK_MPF_RI_BALANCES_V
View Text
SELECT PAF.ROWID ROW_ID
, PPA.PAYROLL_ID
, PAA.ASSIGNMENT_ID
, PAA.ACTION_SEQUENCE
, PBT.BALANCE_TYPE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, PAA.TAX_UNIT_ID
, PAY_HK_EXC.CALCULATED_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, PPA.DATE_EARNED) VALUE
, PPA.EFFECTIVE_DATE
, PAY_HK_EXC.GET_EXPIRY_DATE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID) EXPIRY_DATE
FROM PER_ASSIGNMENTS_F PAF
, PAY_PAYROLL_ACTIONS PPA
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTTL
, PAY_BALANCE_DIMENSIONS PBD
, PAY_DEFINED_BALANCES PDB
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE ((PBT.LEGISLATION_CODE IS NULL
AND PBT.BUSINESS_GROUP_ID = PPA.BUSINESS_GROUP_ID) OR PBT.LEGISLATION_CODE = 'HK')
AND PAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID
AND PBD.DATABASE_ITEM_SUFFIX = '_ASG_MPF_PTD'
AND PBTTL.BALANCE_NAME = 'MPF_RI'
AND EXISTS (SELECT ''
FROM PAY_BALANCE_FEEDS_F PBF
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
WHERE PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND PRRV.INPUT_VALUE_ID = PBF.INPUT_VALUE_ID
AND PBF.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE
AND PBF.EFFECTIVE_END_DATE)
Columns
Name |
ROW_ID |
PAYROLL_ID |
ASSIGNMENT_ID |
ACTION_SEQUENCE |
BALANCE_TYPE_ID |
ASSIGNMENT_ACTION_ID |
BALANCE_NAME |
DEFINED_BALANCE_ID |
DATABASE_ITEM_SUFFIX |
TAX_UNIT_ID |
VALUE |
EFFECTIVE_DATE |
EXPIRY_DATE |