eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_SIF_RET_LEVELS

Line 2196: FROM OKL_SIF_RET_LEVELS

2192: STREAM_INTERFACE_ATTRIBUTE12,
2193: STREAM_INTERFACE_ATTRIBUTE13,
2194: STREAM_INTERFACE_ATTRIBUTE14,
2195: STREAM_INTERFACE_ATTRIBUTE15
2196: FROM OKL_SIF_RET_LEVELS
2197: WHERE SIR_ID = p_sir_id;
2198: CURSOR yields_data_csr (p_trx_number NUMBER) IS
2199: SELECT
2200: SIRB.EFFECTIVE_PRE_TAX_YIELD,

Line 2439: FROM OKL_SIF_RET_LEVELS

2435: STREAM_INTERFACE_ATTRIBUTE12,
2436: STREAM_INTERFACE_ATTRIBUTE13,
2437: STREAM_INTERFACE_ATTRIBUTE14,
2438: STREAM_INTERFACE_ATTRIBUTE15
2439: FROM OKL_SIF_RET_LEVELS
2440: WHERE SIR_ID = p_sir_id;
2441: CURSOR yields_data_csr (p_trx_number NUMBER) IS
2442: SELECT
2443: SIRB.EFFECTIVE_PRE_TAX_YIELD,

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

2670: SRLB.DAYS_IN_PERIOD,
2671: SRLB.FIRST_PAYMENT_DATE,
2672: SIFB.KHR_ID,
2673: SILB.KLE_ID
2674: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB, OKL_STREAM_INTERFACES SIFB,
2675: OKL_SIF_LINES SILB
2676: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2677: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2678: AND SILB.SIF_ID = SIFB.ID

Line 2686: OKL_SIF_RET_LEVELS.ID,

2682: AND SRLB.LOCK_LEVEL_STEP = 'N';
2683:
2684: CURSOR srlv_data_csr (p_trx_number NUMBER) IS
2685: SELECT
2686: OKL_SIF_RET_LEVELS.ID,
2687: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,

Line 2687: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,

2683:
2684: CURSOR srlv_data_csr (p_trx_number NUMBER) IS
2685: SELECT
2686: OKL_SIF_RET_LEVELS.ID,
2687: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,

Line 2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,

2684: CURSOR srlv_data_csr (p_trx_number NUMBER) IS
2685: SELECT
2686: OKL_SIF_RET_LEVELS.ID,
2687: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,

Line 2689: OKL_SIF_RET_LEVELS.SIR_ID,

2685: SELECT
2686: OKL_SIF_RET_LEVELS.ID,
2687: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,

Line 2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,

2686: OKL_SIF_RET_LEVELS.ID,
2687: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,

Line 2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,

2687: OKL_SIF_RET_LEVELS.LEVEL_INDEX_NUMBER,
2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,

Line 2692: OKL_SIF_RET_LEVELS.AMOUNT,

2688: OKL_SIF_RET_LEVELS.NUMBER_OF_PERIODS,
2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,

Line 2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,

2689: OKL_SIF_RET_LEVELS.SIR_ID,
2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,

Line 2694: OKL_SIF_RET_LEVELS.PERIOD,

2690: OKL_SIF_RET_LEVELS.INDEX_NUMBER,
2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,

Line 2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,

2691: OKL_SIF_RET_LEVELS.LEVEL_TYPE,
2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,

Line 2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,

2692: OKL_SIF_RET_LEVELS.AMOUNT,
2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,

Line 2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,

2693: OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS,
2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,

Line 2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,

2694: OKL_SIF_RET_LEVELS.PERIOD,
2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,

Line 2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,

2695: OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP,
2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,

Line 2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,

2696: OKL_SIF_RET_LEVELS.DAYS_IN_PERIOD,
2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,

Line 2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,

2697: OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE,
2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,

Line 2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,

2698: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1,
2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,

Line 2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,

2699: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2,
2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,

Line 2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,

2700: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3,
2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,

Line 2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,

2701: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4,
2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,

Line 2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,

2702: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5,
2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,

Line 2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,

2703: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6,
2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,

Line 2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,

2704: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7,
2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15

Line 2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,

2705: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8,
2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS

Line 2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,

2706: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9,
2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number

Line 2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,

2707: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10,
2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0

Line 2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15

2708: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11,
2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID

Line 2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS

2709: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12,
2710: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13,
2711: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14,
2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'

Line 2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID

2712: OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15
2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2718: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2719: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2720: SELECT

Line 2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'

2713: FROM OKL_SIF_RET_LEVELS, OKL_SIF_RETS
2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2718: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2719: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2720: SELECT
2721: ID

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

2714: WHERE OKL_SIF_RETS.transaction_number = p_trx_number
2715: AND OKL_SIF_RETS.INDEX_NUMBER = 0
2716: AND OKL_SIF_RET_LEVELS.SIR_ID = OKL_SIF_RETS.ID
2717: AND OKL_SIF_RET_LEVELS.LEVEL_TYPE = 'Payment'
2718: AND OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP = 'N';
2719: CURSOR sirv_data_csr (p_trx_number NUMBER) IS
2720: SELECT
2721: ID
2722: FROM okl_sif_rets

Line 3188: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,

3184: SRLB.STREAM_INTERFACE_ATTRIBUTE14,
3185: SRLB.STREAM_INTERFACE_ATTRIBUTE15,
3186: SIFB.KHR_ID,
3187: SILB.KLE_ID
3188: FROM OKL_SIF_RET_LEVELS SRLB, OKL_SIF_RETS SIRB,
3189: OKL_STREAM_INTERFACES SIFB,OKL_SIF_LINES SILB
3190: WHERE SRLB.SIR_ID = p_sir_id
3191: AND SIFB.TRANSACTION_NUMBER = p_trx_number
3192: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER