APPS.FUN_TRX_PVT dependencies on DUAL

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

2474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2476: END IF;
2477: -- Get the next sequence for fun_batch_id
2478: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;
2479: -- Update original batch with reversed_batch_id
2480: UPDATE fun_trx_batches
2481: SET reversed_batch_id = l_reversed_batch_id
2482: WHERE batch_id = p_batch_id;

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

2983: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2985: END IF;
2986: -- Get the next sequence for fun_batch_id
2987: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;
2988:
2989: -- Loop the trx_id table to get sum of debits and credits for txns to be reversed
2990: FOR i IN 1..p_trx_tbl_id.COUNT LOOP
2991: