DBA Data[Home] [Help]

APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKL_SIF_SEQ

Line 56: SELECT okl_sif_seq.nextval

52: | Cursor Declarations |
53: +-----------------------------------------------------------------------*/
54:
55: CURSOR get_next_trx_val_csr IS
56: SELECT okl_sif_seq.nextval
57: FROM dual;
58:
59: /*-----------------------------------------------------------------------+
60: | Local Variable Declarations and initializations |

Line 383: SELECT okl_sif_seq.nextval

379: AND ste.stream_element_date > p_quote_eff_date -- pick streams greater than termination date
380: AND stm.source_id = p_ia_id ;
381:
382: CURSOR get_next_trx_val_csr IS
383: SELECT okl_sif_seq.nextval
384: FROM dual;
385:
386: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
387: l_invdisbas_sty_id NUMBER;

Line 709: SELECT okl_sif_seq.nextval

705: AND ste.stream_element_date > p_quote_eff_date -- pick streams greater than termination date
706: AND stm.source_id = p_ia_id ;
707:
708: CURSOR get_next_trx_val_csr IS
709: SELECT okl_sif_seq.nextval
710: FROM dual;
711:
712: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
713: l_invdisbas_sty_id NUMBER;

Line 1954: SELECT okl_sif_seq.nextval

1950: | Cursor Declarations |
1951: +-----------------------------------------------------------------------*/
1952:
1953: CURSOR get_next_trx_val_csr IS
1954: SELECT okl_sif_seq.nextval
1955: FROM dual;
1956:
1957: /*-----------------------------------------------------------------------+
1958: | Local Variable Declarations and initializations |

Line 2289: SELECT okl_sif_seq.nextval

2285: | Cursor Declarations |
2286: +-----------------------------------------------------------------------*/
2287:
2288: CURSOR get_next_trx_val_csr IS
2289: SELECT okl_sif_seq.nextval
2290: FROM dual;
2291:
2292: /*-----------------------------------------------------------------------+
2293: | Local Variable Declarations and initializations |

Line 2634: SELECT okl_sif_seq.nextval

2630: +-----------------------------------------------------------------------*/
2631:
2632:
2633: CURSOR get_next_trx_val_csr IS
2634: SELECT okl_sif_seq.nextval
2635: FROM dual;
2636:
2637: /*-----------------------------------------------------------------------+
2638: | Local Variable Declarations and initializations |