APPS.BOM_EXPLODER_PUB dependencies on DUAL

Line 1253: to use individual pl/sql table for each column in the cursor select list */

1249: l_batch_size NUMBER := 10000;
1250:
1251: /* Declare pl/sql tables for all coulmns in the select list. BULK BIND and INSERT with
1252: pl/sql table of records work fine in 9i releases but not in 8i. So, the only option is
1253: to use individual pl/sql table for each column in the cursor select list */
1254:
1255:
1256: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER
1257: INDEX BY BINARY_INTEGER;

Line 3226: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;

3222: EXCEPTION WHEN NO_DATA_FOUND
3223: THEN
3224: -- Insert for plan level 0
3225:
3226: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;
3227:
3228: insert INTO BOM_EXPLOSIONS_ALL
3229: (
3230: group_id,