APPS.OKL_LA_STREAM_PVT dependencies on OKL_RBK_SELECTED_CONTRACT

Line 3202: FROM okl_rbk_selected_contract rbk_chr

3198: AND trx.tcn_type = 'TRBK'
3199: AND EXISTS
3200: (
3201: SELECT '1'
3202: FROM okl_rbk_selected_contract rbk_chr
3203: WHERE rbk_chr.khr_id = orig_chr.id
3204: AND rbk_chr.status <> 'PROCESSED'
3205: );
3206:

Line 5573: FROM okl_rbk_selected_contract

5569: IS
5570: SELECT 'Y'
5571: FROM DUAL
5572: WHERE EXISTS (SELECT 'Y'
5573: FROM okl_rbk_selected_contract
5574: WHERE khr_id = p_chr_id
5575: AND status = 'UNDER REVISION');
5576: -- Billable rents
5577:

Line 7061: FROM okl_rbk_selected_contract rbk_khr

7057: AND ktrx.source_trx_type = 'TCN'
7058: AND trx.tcn_type = 'ALT'
7059: AND trx.id = ktrx.source_trx_id
7060: AND EXISTS (SELECT '1'
7061: FROM okl_rbk_selected_contract rbk_khr
7062: WHERE rbk_khr.KHR_ID = chr.id
7063: AND rbk_khr.STATUS <> 'PROCESSED');
7064:
7065: l_api_name CONSTANT VARCHAR2(30) := 'HISTORIZE_VAR_RATE_STREAMS';

Line 7974: FROM okl_rbk_selected_contract rbk_khr

7970: AND ktrx.source_trx_type = 'TCN'
7971: AND trx.tcn_type = 'ALT'
7972: AND trx.id = ktrx.source_trx_id
7973: AND EXISTS (SELECT '1'
7974: FROM okl_rbk_selected_contract rbk_khr
7975: WHERE rbk_khr.KHR_ID = chr.id
7976: AND rbk_khr.STATUS <> 'PROCESSED');
7977:
7978: --Modified by vdamerla for bug 6344223

Line 8123: FROM okl_rbk_selected_contract rbk_khr

8119: AND TXL.QTE_ID = TRX.QTE_ID
8120: AND TXL.qlt_code = 'AMCFIA'
8121: AND TXL.kle_id = p_kle_id
8122: AND EXISTS (SELECT '1'
8123: FROM okl_rbk_selected_contract rbk_khr
8124: WHERE rbk_khr.KHR_ID = chr.id
8125: AND rbk_khr.STATUS <> 'PROCESSED')
8126: AND TXL.QTE_ID = TRX.QTE_ID
8127: UNION -- 24-Mar-2008 sechawla FP fix 7445633 for base bug 7421107 : Added union part

Line 8150: FROM okl_rbk_selected_contract rbk_khr

8146: AND LNK_ITM.DNZ_CHR_ID = p_chr_id
8147: AND LNK_ITM.JTOT_OBJECT1_CODE = 'OKX_COVASST'
8148: AND LNK_ITM.OBJECT1_ID2 = '#'
8149: AND EXISTS (SELECT '1'
8150: FROM okl_rbk_selected_contract rbk_khr
8151: WHERE rbk_khr.KHR_ID = chr.id
8152: AND rbk_khr.STATUS <> 'PROCESSED')
8153: AND TXL.QTE_ID = TRX.QTE_ID;
8154: