APPS.PAY_JP_DEF_ARCHIVE dependencies on DUAL

Line 169: p_sqlstr := 'select 1 from dual where :payroll_action_id < 0';

165: --
166: -- When "process assignments flag" is set to no, no assignment actions are created.
167: --
168: if g_process_assignments_flag = 'N' then
169: p_sqlstr := 'select 1 from dual where :payroll_action_id < 0';
170: else
171: p_sqlstr :=
172: 'select distinct per.person_id
173: from per_all_people_f per,

Line 228: from dual;

224: hr_utility.trace('assignment_id : ' || l_asg_rec.assignment_id);
225: --
226: select pay_assignment_actions_s.nextval
227: into l_assignment_action_id
228: from dual;
229: --
230: hr_nonrun_asact.insact(
231: lockingactid => l_assignment_action_id,
232: assignid => l_asg_rec.assignment_id,