APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_RBK_SELECTED_CONTRACT

Line 6350: FROM okl_rbk_selected_contract rbk_khr

6346: AND ktrx.source_trx_type = 'TCN'
6347: AND trx.tcn_type = 'ALT'
6348: AND trx.id = ktrx.source_trx_id
6349: AND EXISTS (SELECT '1'
6350: FROM okl_rbk_selected_contract rbk_khr
6351: WHERE rbk_khr.KHR_ID = chr.id
6352: AND rbk_khr.STATUS <> 'PROCESSED');
6353:
6354: l_mass_rbk_khr VARCHAR2(1) DEFAULT '?';

Line 6441: FROM okl_rbk_selected_contract rbk_khr

6437: AND TXL.QTE_ID = TRX.QTE_ID
6438: AND TXL.qlt_code = 'AMCFIA'
6439: AND TXL.kle_id = p_kle_id
6440: AND EXISTS (SELECT '1'
6441: FROM okl_rbk_selected_contract rbk_khr
6442: WHERE rbk_khr.KHR_ID = chr.id
6443: AND rbk_khr.STATUS <> 'PROCESSED')
6444: AND TXL.QTE_ID = TRX.QTE_ID
6445:

Line 6470: FROM okl_rbk_selected_contract rbk_khr

6466: AND LNK_ITM.DNZ_CHR_ID = p_chr_id
6467: AND LNK_ITM.JTOT_OBJECT1_CODE = 'OKX_COVASST'
6468: AND LNK_ITM.OBJECT1_ID2 = '#'
6469: AND EXISTS (SELECT '1'
6470: FROM okl_rbk_selected_contract rbk_khr
6471: WHERE rbk_khr.KHR_ID = chr.id
6472: AND rbk_khr.STATUS <> 'PROCESSED')
6473: AND TXL.QTE_ID = TRX.QTE_ID;
6474:

Line 8444: FROM okl_rbk_selected_contract rbk_chr

8440: AND trx.tcn_type = 'TRBK'
8441: AND EXISTS
8442: (
8443: SELECT '1'
8444: FROM okl_rbk_selected_contract rbk_chr
8445: WHERE rbk_chr.khr_id = orig_chr.id
8446: AND rbk_chr.status <> 'PROCESSED'
8447: );
8448: