358: from dual
359: where exists (
360: select 'Y'
361: from pay_run_result_values rrv,
362: pay_input_values_F iv,
363: pay_run_results rr
364: where nvl(rrv.result_value,0) <> to_char(0)
365: and iv.input_value_id = rrv.input_value_id
366: and iv.element_type_id = rr.element_type_id
564: from dual
565: where exists (
566: select 'Y'
567: from pay_run_result_values rrv,
568: pay_input_values_F iv,
569: pay_run_results rr
570: where nvl(rrv.result_value,0) <> to_char(0)
571: and iv.input_value_id = rrv.input_value_id
572: and iv.name = 'Pay Value'