APPS.FUN_TRX_PVT dependencies on DUAL

Line 2316: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;

2312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2314: END IF;
2315: -- Get the next sequence for fun_batch_id
2316: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;
2317: -- Update original batch with reversed_batch_id
2318: UPDATE fun_trx_batches
2319: SET reversed_batch_id = l_reversed_batch_id
2320: WHERE batch_id = p_batch_id;

Line 2767: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;

2763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2765: END IF;
2766: -- Get the next sequence for fun_batch_id
2767: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;
2768:
2769: -- Loop the trx_id table to get sum of debits and credits for txns to be reversed
2770: FOR i IN 1..p_trx_tbl_id.COUNT LOOP
2771: