APPS.PAY_GB_EDI_P46_CAR dependencies on DUAL

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

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

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

609: -- Return cursor that selects no rows
610: sqlstr := 'select 1 '||
611: '/* ERROR - Employer Details Fetch failed with: '||
612: sqlerrm(sqlcode)||' */ '||
613: 'from dual where to_char(:payroll_action_id) = dummy';
614: hr_utility.set_location(' Leaving: '||l_proc,110);
615: END range_code_v3;
616:
617:

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

706: -- Return cursor that selects no rows
707: sqlstr := 'select 1 '||
708: '/* ERROR - Employer Details Fetch failed with: '||
709: sqlerrm(sqlcode)||' */ '||
710: 'from dual where to_char(:payroll_action_id) = dummy';
711: hr_utility.set_location(' Leaving: '||l_proc,110);
712: END range_code_v4;
713:
714: --For Bug 13400872

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

802: -- Return cursor that selects no rows
803: sqlstr := 'select 1 '||
804: '/* ERROR - Employer Details Fetch failed with: '||
805: sqlerrm(sqlcode)||' */ '||
806: 'from dual where to_char(:payroll_action_id) = dummy';
807: hr_utility.set_location(' Leaving: '||l_proc,110);
808: END range_code_v5;
809:
810:

Line 1248: FROM dual;

1244: IF l_create_assact_flag = 'Y' THEN
1245: --
1246: SELECT pay_assignment_actions_s.nextval
1247: INTO l_actid
1248: FROM dual;
1249:
1250: hr_utility.set_location(l_proc, 270);
1251: hr_utility.trace(l_proc||': l_actid='||l_actid);
1252: hr_utility.trace(l_proc||': asg_rec.assignment_id='||asg_rec.assignment_id);

Line 1782: FROM dual;

1778: IF l_create_assact_flag = 'Y' THEN
1779: --
1780: SELECT pay_assignment_actions_s.nextval
1781: INTO l_actid
1782: FROM dual;
1783:
1784: hr_utility.set_location(l_proc, 270);
1785: hr_utility.trace(l_proc||': l_actid='||l_actid);
1786: hr_utility.trace(l_proc||': asg_rec.assignment_id='||asg_rec.assignment_id);

Line 2322: FROM dual;

2318: IF l_create_assact_flag = 'Y' THEN
2319: --
2320: SELECT pay_assignment_actions_s.nextval
2321: INTO l_actid
2322: FROM dual;
2323:
2324: hr_utility.set_location(l_proc, 270);
2325: hr_utility.trace(l_proc||': l_actid='||l_actid);
2326: hr_utility.trace(l_proc||': asg_rec.assignment_id='||asg_rec.assignment_id);

Line 2862: FROM dual;

2858: IF l_create_assact_flag = 'Y' THEN
2859: --
2860: SELECT pay_assignment_actions_s.nextval
2861: INTO l_actid
2862: FROM dual;
2863:
2864: hr_utility.set_location(l_proc, 270);
2865: hr_utility.trace(l_proc||': l_actid='||l_actid);
2866: hr_utility.trace(l_proc||': asg_rec.assignment_id='||asg_rec.assignment_id);