APPS.PAY_JP_DEF_ARCHIVE dependencies on DUAL

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

153: --
154: -- When "process assignments flag" is set to no, no assignment actions are created.
155: --
156: if g_process_assignments_flag = 'N' then
157: p_sqlstr := 'select 1 from dual where :payroll_action_id < 0';
158: else
159: p_sqlstr :=
160: 'select distinct per.person_id
161: from per_all_people_f per,

Line 215: from dual;

211: hr_utility.trace('assignment_id : ' || l_asg_rec.assignment_id);
212: --
213: select pay_assignment_actions_s.nextval
214: into l_assignment_action_id
215: from dual;
216: --
217: hr_nonrun_asact.insact(
218: lockingactid => l_assignment_action_id,
219: assignid => l_asg_rec.assignment_id,