DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_RBK_SELECTED_CONTRACT

Line 4474: FROM okl_rbk_selected_contract

4470: IS
4471: SELECT 'Y'
4472: FROM DUAL
4473: WHERE EXISTS (SELECT 'Y'
4474: FROM okl_rbk_selected_contract
4475: WHERE khr_id = p_chr_id
4476: AND status = 'UNDER REVISION');
4477: -- Billable rents
4478:

Line 6536: FROM okl_rbk_selected_contract rbk_khr

6532: AND ktrx.source_trx_type = 'TCN'
6533: AND trx.tcn_type = 'ALT'
6534: AND trx.id = ktrx.source_trx_id
6535: AND EXISTS (SELECT '1'
6536: FROM okl_rbk_selected_contract rbk_khr
6537: WHERE rbk_khr.KHR_ID = chr.id
6538: AND rbk_khr.STATUS <> 'PROCESSED');
6539:
6540: --Modified by vdamerla for bug 6344223

Line 6684: FROM okl_rbk_selected_contract rbk_khr

6680: AND TXL.QTE_ID = TRX.QTE_ID
6681: AND TXL.qlt_code = 'AMCFIA'
6682: AND TXL.kle_id = p_kle_id
6683: AND EXISTS (SELECT '1'
6684: FROM okl_rbk_selected_contract rbk_khr
6685: WHERE rbk_khr.KHR_ID = chr.id
6686: AND rbk_khr.STATUS <> 'PROCESSED')
6687: AND TXL.QTE_ID = TRX.QTE_ID;
6688: