159: --
160: hr_utility.set_location(l_proc,10);
161: select pay_retro_assignments_s.nextval
162: into p_retro_assignment_id
163: from sys.dual;
164: --
165: l_creation_status := get_creation_status(p_payroll_id);
166:
167: INSERT INTO pay_retro_assignments
439: (itemtype => itemtype,
440: itemkey => itemkey,
441: aname => an_retro_asg_nums,
442: aValue => l_ppe_id||' <- ->'||l_column_name);
443: --execute immediate 'select 1 from dual' into l_usr_id;
444:
445: execute immediate l_statement into l_usr_id;
446:
447: if (l_usr_id is not null and l_usr_id <> -1) then