APPS.BOM_EXPLODER_PUB dependencies on DUAL

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

1329: l_batch_size NUMBER := 10000;
1330:
1331: /* Declare pl/sql tables for all coulmns in the select list. BULK BIND and INSERT with
1332: pl/sql table of records work fine in 9i releases but not in 8i. So, the only option is
1333: to use individual pl/sql table for each column in the cursor select list */
1334:
1335:
1336: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER
1337: INDEX BY BINARY_INTEGER;

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

3336: EXCEPTION WHEN NO_DATA_FOUND
3337: THEN
3338: -- Insert for plan level 0
3339:
3340: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;
3341:
3342: insert INTO BOM_EXPLOSIONS_ALL
3343: (
3344: group_id,