[Home] [Help]
1945: or(paa1.run_type_id is null and paa1.source_action_id is null))
1946: and exists (
1947: select 'Y'
1948: from pay_run_result_values rrv,
1949: pay_input_values_F iv,
1950: pay_run_results rr
1951: where nvl(rrv.result_value,0) <> to_char(0)
1952: and iv.input_value_id = rrv.input_value_id
1953: and iv.name = 'Pay Value'