203: ) IS
204:
205: CURSOR get_new_id IS
206: SELECT gl_budget_assignment_ranges_s.NEXTVAL 207: FROM dual; 208:
209:
210: CURSOR C IS SELECT rowid FROM GL_BUDGET_ASSIGNMENT_RANGES
211:
Line 216: FROM DUAL
212: WHERE range_id = X_Range_Id;
213:
214: CURSOR check_overlaps IS
215: SELECT 'Overlapping' 216: FROM DUAL 217: WHERE EXISTS
218: (SELECT 'X'
219: FROM GL_BUDGET_ASSIGNMENT_RANGES
220: WHERE LEDGER_ID = X_LEDGER_ID