APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on DUAL

Line 627: FROM dual;

623: l_sqlerrmsg varchar2(2000);
624:
625: CURSOR l_onhand_acc_seq IS
626: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL
627: FROM dual;
628:
629: -- post deletes to onhand
630: CURSOR l_onhand_delete_csr IS
631: SELECT /*+ index(ohqacc CSM_MTL_ONHAND_QTY_ACC_U2) */ ohqacc.user_id

Line 950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;

946: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
947: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
948:
949: FOR i IN inv_id.FIRST..inv_id.LAST LOOP
950: SELECT csm_mtl_onhand_qty_acc_s.NEXTVAL INTO acc_id_lst(i) FROM dual;
951: END LOOP;
952:
953: FORALL i IN inv_id.FIRST..inv_id.LAST
954: INSERT INTO CSM_MTL_ONHAND_QTY_ACC (ACCESS_ID, user_id, INVENTORY_ITEM_ID,ORGANIZATION_ID,