APPS.PAY_RETRO_UTILS_PKG dependencies on DUAL

Line 196: from sys.dual;

192: --
193: hr_utility.set_location(l_proc,10);
194: select pay_retro_assignments_s.nextval
195: into p_retro_assignment_id
196: from sys.dual;
197: --
198: l_creation_status := get_creation_status(p_payroll_id);
199:
200: INSERT INTO pay_retro_assignments

Line 473: --execute immediate 'select 1 from dual' into l_usr_id;

469: (itemtype => itemtype,
470: itemkey => itemkey,
471: aname => an_retro_asg_nums,
472: aValue => l_ppe_id||' <- ->'||l_column_name);
473: --execute immediate 'select 1 from dual' into l_usr_id;
474:
475: execute immediate l_statement into l_usr_id;
476:
477: if (l_usr_id is not null and l_usr_id <> -1) then