DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_RBK_SELECTED_CONTRACT

Line 6758: FROM okl_rbk_selected_contract rbk_khr

6754: AND ktrx.rbr_code IS NOT NULL
6755: AND ktrx.tcn_type = 'TRBK'
6756: AND ktrx.representation_type = 'PRIMARY' -- MGAAP 7263041
6757: AND EXISTS (SELECT '1'
6758: FROM okl_rbk_selected_contract rbk_khr
6759: WHERE rbk_khr.khr_id = chr.id
6760: AND rbk_khr.status <> 'PROCESSED');
6761:
6762: CURSOR curr_streams_csr(p_khr_id IN NUMBER) IS

Line 9055: FROM okl_rbk_selected_contract rbk_khr

9051: AND ktrx.rbr_code IS NOT NULL
9052: AND ktrx.tcn_type = 'TRBK'
9053: AND ktrx.representation_type = 'PRIMARY' -- MGAAP 7263041
9054: AND EXISTS (SELECT '1'
9055: FROM okl_rbk_selected_contract rbk_khr
9056: WHERE rbk_khr.khr_id = chr.id
9057: AND rbk_khr.status <> 'PROCESSED');
9058:
9059: CURSOR curr_streams_csr(p_khr_id IN NUMBER) IS