APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_STREAM_INTERFACES

Line 220: FROM okl_stream_interfaces

216:
217: CURSOR c_supertrump_csr (a_id IN NUMBER)
218: IS
219: SELECT sis_code
220: FROM okl_stream_interfaces
221: WHERE ID=a_id;
222:
223: l_status_code VARCHAR2(80);
224: l_object1_id1 VARCHAR2(40);

Line 236: IF l_object1_code = 'OKL_STREAM_INTERFACES' THEN

232: CLOSE c_cs_Status_csr;
233:
234: IF l_status_code='SUBMITTED_CALCULATION' THEN
235: --Still not processed, Check for the status in Streams table.
236: IF l_object1_code = 'OKL_STREAM_INTERFACES' THEN
237: open c_supertrump_csr(l_object1_id1);
238: FETCH c_supertrump_csr INTO l_sis_code;
239: CLOSE c_supertrump_csr;
240: END IF;

Line 3520: l_trqv_tbl(1).jtot_object1_code := 'OKL_STREAM_INTERFACES';

3516: close c_get_object_ver;
3517:
3518: l_trqv_tbl(1).id := x_trqv_tbl(1).id;
3519: l_trqv_tbl(1).object_version_number := l_object_version_number;--x_trqv_tbl(1).object_version_number;
3520: l_trqv_tbl(1).jtot_object1_code := 'OKL_STREAM_INTERFACES';
3521: l_trqv_tbl(1).object1_id1 := l_trans_id;
3522: if (l_object_version_number = x_trqv_tbl(1).object_version_number) then
3523: l_trqv_tbl(1).request_status_code := 'PRICING';
3524: end if ;