DBA Data[Home] [Help]

APPS.PAY_JP_PRE_TAX_ARCHIVE dependencies on DUAL

Line 210: from dual;

206: hr_utility.trace('assignment_id : ' || l_assact_rec.assignment_id);
207: --
208: select pay_assignment_actions_s.nextval
209: into l_locking_action_id
210: from dual;
211: --
212: hr_utility.trace('archive assignment_action_id : ' || l_locking_action_id);
213: --
214: hr_nonrun_asact.insact(

Line 285: from dual

281: c_proc constant varchar2(61) := c_package || 'deinitialization_code';
282: l_dummy varchar2(1);
283: cursor csr_remove_actions is
284: select 'Y'
285: from dual
286: where not exists(
287: select null
288: from pay_assignment_actions
289: where payroll_action_id = p_payroll_action_id