APPS.PAY_JP_PRE_TAX_ARCHIVE dependencies on DUAL

Line 201: from dual;

197: hr_utility.trace('assignment_id : ' || l_assact_rec.assignment_id);
198: --
199: select pay_assignment_actions_s.nextval
200: into l_locking_action_id
201: from dual;
202: --
203: hr_utility.trace('archive assignment_action_id : ' || l_locking_action_id);
204: --
205: hr_nonrun_asact.insact(

Line 274: from dual

270: c_proc constant varchar2(61) := c_package || 'deinitialization_code';
271: l_dummy varchar2(1);
272: cursor csr_remove_actions is
273: select 'Y'
274: from dual
275: where not exists(
276: select null
277: from pay_assignment_actions
278: where payroll_action_id = p_payroll_action_id