APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_RBK_SELECTED_CONTRACT

Line 8427: FROM okl_rbk_selected_contract rbk_khr

8423: AND ktrx.rbr_code IS NOT NULL
8424: AND ktrx.tcn_type = 'TRBK'
8425: AND ktrx.representation_type = 'PRIMARY' -- MGAAP 7263041
8426: AND EXISTS (SELECT '1'
8427: FROM okl_rbk_selected_contract rbk_khr
8428: WHERE rbk_khr.khr_id = chr.id
8429: AND rbk_khr.status <> 'PROCESSED');
8430:
8431: CURSOR curr_streams_csr(p_khr_id IN NUMBER) IS

Line 10755: FROM okl_rbk_selected_contract rbk_khr

10751: -- ID of this transaction (ktrx.id) is stamped on both primary and reporting streams
10752: AND ktrx.tcn_type = 'TRBK'
10753: AND ktrx.representation_type = 'PRIMARY' -- MGAAP 7263041
10754: AND EXISTS (SELECT '1'
10755: FROM okl_rbk_selected_contract rbk_khr
10756: WHERE rbk_khr.khr_id = chr.id
10757: AND rbk_khr.status <> 'PROCESSED');
10758:
10759: /*

Line 10773: FROM okl_rbk_selected_contract rbk_khr

10769: AND ktrx.rbr_code IS NOT NULL
10770: AND ktrx.tcn_type = 'TRBK'
10771: AND ktrx.representation_type = 'SECONDARY'
10772: AND EXISTS (SELECT '1'
10773: FROM okl_rbk_selected_contract rbk_khr
10774: WHERE rbk_khr.khr_id = chr.id
10775: AND rbk_khr.status <> 'PROCESSED');
10776: */
10777: