DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on DUAL

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

170: EXCEPTION
171: WHEN OTHERS THEN
172: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);
173: -- Return cursor that selects no rows
174: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
175: END range_cursor;
176: ---------------------------------------------------------------------------------------------------
177: -- ACTION CREATION --
178: -- DESCRIPTION : Creates new assignment actions under the (archive) payroll action

Line 246: FROM dual;

242: EXIT WHEN csr_assignments%NOTFOUND;
243: -- create the action
244: SELECT pay_assignment_actions_s.nextval
245: INTO l_actid
246: FROM dual;
247: hr_nonrun_asact.insact(l_actid
248: ,rec_this.assignment_id
249: ,pactid
250: ,chunk