APPS.PAY_SA_HIST_ARCH_PKG dependencies on DUAL

Line 100: 'from dual where to_char(:payroll_action_id) = dummy';

96: then
97: sqlstr := 'select 1 '||
98: '/* ERROR - Employer Details Fetch failed with: '||
99: sqlerrm(sqlcode)||' */ '||
100: 'from dual where to_char(:payroll_action_id) = dummy';
101:
102: hr_utility.set_location('Exception occured in range_cursor: '||SQLERRM,30);
103: raise;
104: end range_cursor;

Line 189: from dual;

185: for asgrec in get_arch_action_det(l_payroll_id,l_bg_id,l_start_date,l_end_date)
186: loop
187: select pay_assignment_actions_s.nextval
188: into lockingactid
189: from dual;
190:
191: hr_nonrun_asact.insact
192: (
193: lockingactid => lockingactid,