View: PAY_HK_ASG_SCHEME_NAME_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.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