1635: sum(decode(piv.name, 'Rate', prrv.result_value))
1636: from pay_run_results prr,
1637: pay_run_result_values prrv,
1638: pay_input_values_f piv,
1639: pay_entry_process_details pepd
1640: where piv.input_value_id = prrv.input_value_id
1641: and prr.element_type_id = cp_element_type_id
1642: and prr.run_result_id = prrv.run_result_id
1643: and prr.assignment_action_id = cp_run_action_id
4850: select PRRV.RESULT_VALUE as original_input_value
4851: from pay_run_results PRR,
4852: pay_run_result_values PRRV,
4853: pay_input_values_f PIVF,
4854: pay_entry_process_details PEPD
4855: WHERE PEPD.ELEMENT_ENTRY_ID = cp_element_entry_id
4856: AND PEPD.SOURCE_ENTRY_ID = PRR.SOURCE_ID
4857: AND PEPD.RUN_RESULT_ID = PRR.RUN_RESULT_ID
4858: AND PEPD.SOURCE_ELEMENT_TYPE_ID = PIVF.ELEMENT_TYPE_ID