[Home] [Help]
View: PAY_HK_ASG_SCHEME_NAME_V
View Text
SELECT PRR.RUN_RESULT_ID RUN_RESULT_ID
, PRRV.INPUT_VALUE_ID INPUT_VALUE_ID
, PRRV.RESULT_VALUE SCHEME_ID
, HOI.ORG_INFORMATION2 SCHEME_NAME
FROM PAY_INPUT_VALUES_F PIVF
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, HR_ORGANIZATION_INFORMATION HOI
WHERE PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND PIVF.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PRRV.RESULT_VALUE = HOI.ORG_INFORMATION20
AND HOI.ORG_INFORMATION_CONTEXT = 'HK_MPF_SCHEMES'
AND PIVF.LEGISLATION_CODE = 'HK'
AND PIVF.NAME = 'SOURCE'
Columns
Name |
RUN_RESULT_ID |
INPUT_VALUE_ID |
SCHEME_ID |
SCHEME_NAME |