APPS.PAY_FR_DADS_PKG dependencies on DUAL

Line 57: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

53: EXCEPTION
54: WHEN OTHERS THEN
55: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);
56: -- Return cursor that selects no rows
57: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
58: END range_cursor;
59: -------------------------------------------------------------------------------
60: -- ACTION CREATION --
61: -- DESCRIPTION : Creates new assignment actions under the (archive)

Line 146: FROM dual;

142: -- create a new action and lock the fetched one
143: --
144: SELECT pay_assignment_actions_s.NEXTVAL
145: INTO l_actid
146: FROM dual;
147: --
148: hr_nonrun_asact.insact(l_actid
149: ,l_qualify_asg_rec.assignment_id
150: ,pactid