432: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
433: from pay_assignment_actions aa
434: , pay_run_results rr
435: , pay_run_result_values rrv
436: , pay_input_values_f iv
437: , pay_input_values_f_tl ivtl
438: , pay_element_types_f et
439: , pay_element_types_f_tl ettl
440: where aa.assignment_action_id :action_clause
433: from pay_assignment_actions aa
434: , pay_run_results rr
435: , pay_run_result_values rrv
436: , pay_input_values_f iv
437: , pay_input_values_f_tl ivtl
438: , pay_element_types_f et
439: , pay_element_types_f_tl ettl
440: where aa.assignment_action_id :action_clause
441: and aa.assignment_action_id = rr.assignment_action_id
505: l_assignment_id number;
506: l_business_group_id number;
507: l_legislation_code varchar2(30);
508: l_save_asg_run_bal varchar2(30);
509: l_inp_val_name pay_input_values_f.name%type;
510: l_si_needed_chr varchar2(10);
511: l_st_needed_chr varchar2(10);
512: l_sn_needed_chr varchar2(10);
513: l_st2_needed_chr varchar2(10);
830: , rr.run_result_id COL18
831: from pay_assignment_actions aa
832: , pay_run_results rr
833: , pay_run_result_values rrv
834: , pay_input_values_f iv
835: , pay_input_values_f_tl ivtl
836: , pay_element_types_f et
837: , pay_element_types_f_tl ettl
838: , hr_organization_information oi
831: from pay_assignment_actions aa
832: , pay_run_results rr
833: , pay_run_result_values rrv
834: , pay_input_values_f iv
835: , pay_input_values_f_tl ivtl
836: , pay_element_types_f et
837: , pay_element_types_f_tl ettl
838: , hr_organization_information oi
839: where aa.assignment_action_id :action_clause