843: and payroll_id = l_payroll_id;
844:
845: cursor cur_payroll_run_type is
846: select t.run_type_name
847: from pay_run_types_f_tl t,
848: pay_run_types_f r
849: where r.run_type_id = to_number(p_payroll_run_type)
850: and r.run_type_id = t.run_type_id
851: and t.language = userenv('LANG')
2972: and payroll_id = l_payroll_id;
2973:
2974: cursor cur_payroll_run_type is
2975: select t.run_type_name
2976: from pay_run_types_f_tl t,
2977: pay_run_types_f r
2978: where r.run_type_id = to_number(p_payroll_run_type)
2979: and r.run_type_id = t.run_type_id
2980: and t.language = userenv('LANG')