DBA Data[Home] [Help]

APPS.PAY_FR_DUCS dependencies on DUAL

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

237: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,100);
238:
239: hr_utility.set_message(801, 'PAY_75086_DUCS_DUPLICATE_ARCH');
240: FND_FILE.PUT_LINE(fnd_file.log,substr(hr_utility.get_message,1,240));
241: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
242:
243:
244: WHEN OTHERS THEN
245: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,100);

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

243:
244: WHEN OTHERS THEN
245: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,100);
246: -- Return cursor that selects no rows
247: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
248: hr_utility.set_location('Quitting ' || l_proc,10);
249:
250: END range_code;
251:

Line 439: FROM dual;

435: if l_create_act then
436: -- insert the new assignment action
437: SELECT pay_assignment_actions_s.nextval
438: INTO l_actid
439: FROM dual;
440: hr_nonrun_asact.insact( l_actid
441: , rec_assact.assignment_id
442: , p_payroll_action_id
443: , p_chunk