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 3220: FROM okl_trx_contracts trxc

3216: -- revision contract: rebook, split contract, reverse
3217: CURSOR l_okl_poc_rev_csr(p_dnz_chr_id IN NUMBER)
3218: IS
3219: SELECT '1'
3220: FROM okl_trx_contracts trxc
3221: WHERE trxc.tcn_type IN ('TRBK','SPLC','RVS')
3222: AND trxc.tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED')
3223: AND trxc.khr_id = p_dnz_chr_id;
3224:

Line 4175: FROM okl_trx_contracts trxb

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

Line 4361: FROM okl_trx_contracts trxb

4357: -- cklee 04/10/2003 never reconcile historical data
4358: -- AND chrb.sts_code = 'BOOKED'
4359: AND EXISTS -- revision contract: rebook, split contract, reverse
4360: (SELECT '1'
4361: FROM okl_trx_contracts trxb
4362: WHERE trxb.tcn_type IN ('TRBK','SPLC','RVS')
4363: -- AND trxb.tsu_code = 'ENTERED'
4364: AND trxb.tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED') -- condition changes 01/13/2003 cklee
4365: AND trxb.khr_id = poc.khr_id