APPS.PYNEGNET01 dependencies on PAY_RUN_RESULT_VALUES

Line 2195: from pay_run_result_values prrv,

2191: l_result_value varchar2(60);
2192:
2193: cursor csr_run_results is
2194: select prrv.run_result_id, prrv.input_value_id, prrv.result_value
2195: from pay_run_result_values prrv,
2196: pay_input_values_f pivf,
2197: pay_element_types_f petf
2198: where prrv.input_value_id = pivf.input_value_id and
2199: upper(pivf.name) = 'PAY VALUE' and

Line 2212: update pay_run_result_values

2208:
2209: WHILE csr_run_results%found LOOP
2210:
2211: if fnd_number.canonical_to_number(l_result_value) > 0 then
2212: update pay_run_result_values
2213: set result_value = fnd_number.number_to_canonical(fnd_number.canonical_to_number(result_value) * (-1))
2214: where run_result_id = l_run_result_id and
2215: input_value_id = l_input_value_id;
2216: end if;