APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_SIF_RET_LEVELS

Line 2249: FROM OKL_SIF_RET_LEVELS

2245: STREAM_INTERFACE_ATTRIBUTE12,
2246: STREAM_INTERFACE_ATTRIBUTE13,
2247: STREAM_INTERFACE_ATTRIBUTE14,
2248: STREAM_INTERFACE_ATTRIBUTE15
2249: FROM OKL_SIF_RET_LEVELS
2250: WHERE SIR_ID = p_sir_id;
2251: CURSOR yields_data_csr (p_trx_number NUMBER) IS
2252: SELECT
2253: SIRB.EFFECTIVE_PRE_TAX_YIELD,

Line 2492: FROM OKL_SIF_RET_LEVELS

2488: STREAM_INTERFACE_ATTRIBUTE12,
2489: STREAM_INTERFACE_ATTRIBUTE13,
2490: STREAM_INTERFACE_ATTRIBUTE14,
2491: STREAM_INTERFACE_ATTRIBUTE15
2492: FROM OKL_SIF_RET_LEVELS
2493: WHERE SIR_ID = p_sir_id;
2494: CURSOR yields_data_csr (p_trx_number NUMBER) IS
2495: SELECT
2496: SIRB.EFFECTIVE_PRE_TAX_YIELD,

Line 2727: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,

2723: SRLB.DAYS_IN_PERIOD,
2724: SRLB.FIRST_PAYMENT_DATE,
2725: SIFB.KHR_ID,
2726: SILB.KLE_ID
2727: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,
2728: OKL_SIF_LINES SILB
2729: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2730: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2731: AND SILB.SIF_ID = SIFB.ID

Line 2739: OKL_SIF_RET_LEVELS.ID,

2735: AND SRLB.LOCK_LEVEL_STEP = 'N';
2736:
2737: CURSOR srlv_data_csr (p_trx_number NUMBER) IS
2738: SELECT
2739: OKL_SIF_RET_LEVELS.ID,
2740: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,

Line 2740: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,

2736:
2737: CURSOR srlv_data_csr (p_trx_number NUMBER) IS
2738: SELECT
2739: OKL_SIF_RET_LEVELS.ID,
2740: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,

Line 2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,

2737: CURSOR srlv_data_csr (p_trx_number NUMBER) IS
2738: SELECT
2739: OKL_SIF_RET_LEVELS.ID,
2740: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,

Line 2742: OKL_SIF_RET_LEVELS.SIR_ID,

2738: SELECT
2739: OKL_SIF_RET_LEVELS.ID,
2740: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,

Line 2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,

2739: OKL_SIF_RET_LEVELS.ID,
2740: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,

Line 2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,

2740: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,

Line 2745: OKL_SIF_RET_LEVELS.AMOUNT,

2741: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,

Line 2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,

2742: OKL_SIF_RET_LEVELS.SIR_ID,
2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,

Line 2747: OKL_SIF_RET_LEVELS.PERIOD,

2743: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,

Line 2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,

2744: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,

Line 2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,

2745: OKL_SIF_RET_LEVELS.AMOUNT,
2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,

Line 2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,

2746: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,

Line 2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,

2747: OKL_SIF_RET_LEVELS.PERIOD,
2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,

Line 2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,

2748: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,

Line 2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,

2749: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,

Line 2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,

2750: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,

Line 2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,

2751: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,

Line 2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,

2752: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,

Line 2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,

2753: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,

Line 2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,

2754: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,

Line 2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,

2755: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,

Line 2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,

2756: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,

Line 2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,

2757: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15

Line 2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,

2758: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS

Line 2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,

2759: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number

Line 2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,

2760: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0

Line 2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15

2761: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID

Line 2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS

2762: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2763: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2764: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'

Line 2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID

2765: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2772: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2773: SELECT

Line 2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'

2766: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2772: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2773: SELECT
2774: ID

Line 2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';

2767: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2768: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2769: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2770: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2771: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2772: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2773: SELECT
2774: ID
2775: FROM okl_sif_rets

Line 3245: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,

3241: SIFB.KHR_ID,
3242: SILB.KLE_ID,
3243: SIFB.ID SIF_ID,
3244: SILB.ID SIL_ID
3245: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,
3246: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB
3247: WHERE SRLB.SIR_ID = p_sir_id
3248: AND SIFB.TRANSACTION_NUMBER = p_trx_number
3249: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER