APPS.OKL_POOL_PVT dependencies on OKL_TRX_CONTRACTS

Line 2680: FROM okl_trx_contracts trxc

2676: AND rg.rule_information1 = 'Y'
2677: AND rgp.dnz_chr_id = pol.dnz_chr_id)
2678: AND NOT EXISTS -- revision contract: rebook, split contract, reverse
2679: (SELECT '1'
2680: FROM okl_trx_contracts trxc
2681: WHERE trxc.tcn_type IN ('TRBK','SPLC','RVS')
2682: AND trxc.tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED') -- condition changes 01/13/2003 cklee
2683: AND trxc.khr_id = pol.dnz_chr_id)
2684: AND NOT EXISTS -- split assets, split assets components

Line 2807: FROM okl_trx_contracts

2803: AND rg.rule_information1 = 'Y'
2804: AND rgp.dnz_chr_id = pol.dnz_chr_id)
2805: AND NOT EXISTS -- revision contract: rebook, split contract, reverse
2806: (SELECT '1'
2807: FROM okl_trx_contracts
2808: WHERE tcn_type IN ('TRBK','SPLC','RVS')
2809: AND tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED') -- condition changes 01/13/2003 cklee
2810: AND khr_id = pol.dnz_chr_id)
2811: AND NOT EXISTS -- split assets, split assets components

Line 3214: FROM okl_trx_contracts trxc

3210: -- revision contract: rebook, split contract, reverse
3211: CURSOR l_okl_poc_rev_csr(p_dnz_chr_id IN NUMBER)
3212: IS
3213: SELECT '1'
3214: FROM okl_trx_contracts trxc
3215: WHERE trxc.tcn_type IN ('TRBK','SPLC','RVS')
3216: AND trxc.tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED')
3217: AND trxc.khr_id = p_dnz_chr_id;
3218:

Line 4169: FROM okl_trx_contracts trxb

4165: -- cklee 04/10/2003 never reconcile historical data
4166: -- AND chrb.sts_code = 'BOOKED'
4167: AND EXISTS -- revision contract: rebook, split contract, reverse
4168: (SELECT '1'
4169: FROM okl_trx_contracts trxb
4170: WHERE trxb.tcn_type IN ('TRBK','SPLC','RVS')
4171: -- AND trxb.tsu_code = 'ENTERED'
4172: AND trxb.tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED') -- condition changes 01/13/2003 cklee
4173: AND trxb.khr_id = poc.khr_id

Line 4354: FROM okl_trx_contracts trxb

4350: -- cklee 04/10/2003 never reconcile historical data
4351: -- AND chrb.sts_code = 'BOOKED'
4352: AND EXISTS -- revision contract: rebook, split contract, reverse
4353: (SELECT '1'
4354: FROM okl_trx_contracts trxb
4355: WHERE trxb.tcn_type IN ('TRBK','SPLC','RVS')
4356: -- AND trxb.tsu_code = 'ENTERED'
4357: AND trxb.tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED') -- condition changes 01/13/2003 cklee
4358: AND trxb.khr_id = poc.khr_id