DBA Data[Home] [Help]

APPS.IGI_EFC_UPGRADE dependencies on DUAL

Line 1443: FROM dual;

1439: fnd_file.put_line(fnd_file.output,'Ledger - Budget Organization - Currency - Range From - Range To ');
1440: BEGIN
1441: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1442: INTO l_range_id_seq
1443: FROM dual;
1444: l_range_id_seq := l_range_id_seq + 1;
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');

Line 1476: FROM dual;

1472: IF p_mode = 1 THEN
1473: BEGIN
1474: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1475: INTO l_actual_range_id
1476: FROM dual;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1480: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'

Line 2977: SELECT 1 FROM DUAL WHERE EXISTS

2973: IS
2974: -- This cursor determines whether overlapping ranges exist
2975: -- This is used to determine whether to proceed with the upgrade or not
2976: CURSOR C_OVERLAPPING_RANGE_EXISTS IS
2977: SELECT 1 FROM DUAL WHERE EXISTS
2978: (
2979: SELECT 1 FROM GL_BUDGET_ASSIGNMENT_RANGES BA1
2980: WHERE EXISTS
2981: (SELECT 1 FROM