DBA Data[Home] [Help]

APPS.IGI_EFC_UPGRADE dependencies on DUAL

Line 1194: FROM dual;

1190: fnd_file.put_line(fnd_file.output,'Ledger - Budget Organization - Currency - Range From - Range To ');
1191: BEGIN
1192: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1193: INTO l_range_id_seq
1194: FROM dual;
1195: l_range_id_seq := l_range_id_seq + 1;
1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');

Line 1223: FROM dual;

1219: IF p_mode = 1 THEN
1220: BEGIN
1221: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1222: INTO l_actual_range_id
1223: FROM dual;
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1227: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'

Line 2628: SELECT 1 FROM DUAL WHERE EXISTS

2624: )
2625: IS
2626:
2627: CURSOR C_OVERLAPPING_RANGE_EXISTS IS
2628: SELECT 1 FROM DUAL WHERE EXISTS
2629: (
2630: SELECT 1 FROM GL_BUDGET_ASSIGNMENT_RANGES BA1
2631: WHERE EXISTS
2632: (SELECT 1 FROM