eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_HK_ASG_SCHEME_NAME_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'