APPS.PAY_GB_EDI_P46_CAR dependencies on DUAL

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

415: -- Return cursor that selects no rows
416: sqlstr := 'select 1 '||
417: '/* ERROR - Employer Details Fetch failed with: '||
418: sqlerrm(sqlcode)||' */ '||
419: 'from dual where to_char(:payroll_action_id) = dummy';
420: hr_utility.set_location(' Leaving: '||l_proc,110);
421: END range_cursor;
422:
423: --For Bug 6652235

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

512: -- Return cursor that selects no rows
513: sqlstr := 'select 1 '||
514: '/* ERROR - Employer Details Fetch failed with: '||
515: sqlerrm(sqlcode)||' */ '||
516: 'from dual where to_char(:payroll_action_id) = dummy';
517: hr_utility.set_location(' Leaving: '||l_proc,110);
518: END range_code;
519:
520: -----------------------------------------------------

Line 956: FROM dual;

952: IF l_create_assact_flag = 'Y' THEN
953: --
954: SELECT pay_assignment_actions_s.nextval
955: INTO l_actid
956: FROM dual;
957:
958: hr_utility.set_location(l_proc, 270);
959: hr_utility.trace(l_proc||': l_actid='||l_actid);
960: hr_utility.trace(l_proc||': asg_rec.assignment_id='||asg_rec.assignment_id);

Line 1421: FROM dual;

1417: IF l_create_assact_flag = 'Y' THEN
1418: --
1419: SELECT pay_assignment_actions_s.nextval
1420: INTO l_actid
1421: FROM dual;
1422:
1423: hr_utility.set_location(l_proc, 270);
1424: hr_utility.trace(l_proc||': l_actid='||l_actid);
1425: hr_utility.trace(l_proc||': asg_rec.assignment_id='||asg_rec.assignment_id);