APPS.PAY_GB_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 190: from dual;

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