APPS.OKL_POOL_PVT dependencies on OKL_K_HEADERS

Line 2174: l_deal_type okl_k_headers.deal_type%TYPE;

2170: x_msg_count NUMBER;
2171: x_msg_data VARCHAR2(1999);
2172: x_value NUMBER := 0;
2173: l_ctxt_val_tbl Okl_Execute_Formula_Pvt.ctxt_val_tbl_type;
2174: l_deal_type okl_k_headers.deal_type%TYPE;
2175: l_contract_number okc_k_headers_b.contract_number%TYPE;
2176:
2177: l_formula_name VARCHAR2(100);
2178: /*

Line 2191: okl_k_headers khr

2187: , G_DEAL_TYPE_LEASEOP, G_NET_INVESTMENT_OP
2188: , G_NET_INVESTMENT_OTHERS)
2189: FROM okl_pool_contents poc,
2190: okc_k_headers_b CHR,
2191: okl_k_headers khr
2192: WHERE poc.khr_id = CHR.id
2193: AND khr.id = CHR.id
2194: AND poc.pol_id = p_pol_id
2195: ;

Line 2205: FROM okl_k_headers khr

2201: , G_DEAL_TYPE_LEASEST, G_NET_INVESTMENT_DF
2202: , G_DEAL_TYPE_LOAN, G_NET_INVESTMENT_LOAN
2203: , G_DEAL_TYPE_LEASEOP, G_NET_INVESTMENT_OP
2204: , G_NET_INVESTMENT_OTHERS)
2205: FROM okl_k_headers khr
2206: WHERE EXISTS (SELECT '1'
2207: FROM okl_pool_contents poc
2208: WHERE khr.id = poc.khr_id
2209: AND poc.pol_id = p_pol_id

Line 2219: okl_k_headers khr

2215: IS
2216: SELECT CHR.contract_number,
2217: khr.deal_type
2218: FROM okc_k_headers_b CHR,
2219: okl_k_headers khr
2220: WHERE CHR.id = khr.id
2221: AND CHR.id = p_chr_id
2222: ;
2223:

Line 3273: FROM okl_k_headers khr,

3269: -- then raise an error
3270: CURSOR l_okl_reject_le_csr(p_khr_id IN NUMBER)
3271: IS
3272: SELECT '1'
3273: FROM okl_k_headers khr,
3274: okl_pools pol
3275: WHERE pol.legal_entity_id <> khr.legal_entity_id
3276: AND pol.id =p_pol_id
3277: AND khr.id = p_khr_id;

Line 4137: okl_k_headers khrb

4133: -- to remove all contents pointing to invalid contracts
4134: SELECT poc.id
4135: FROM okl_pool_contents poc,
4136: okc_k_headers_b chrb,
4137: okl_k_headers khrb
4138: WHERE poc.pol_id = p_pol_id
4139: AND poc.khr_id = chrb.id
4140: AND poc.khr_id = khrb.id
4141: -- cklee 04/10/2003 never reconcile historical data

Line 4323: okl_k_headers khrb

4319: -- to remove all contents pointing to invalid contracts
4320: SELECT poc.id
4321: FROM okl_pool_contents poc,
4322: okc_k_headers_b chrb,
4323: okl_k_headers khrb
4324: WHERE poc.pol_id = p_pol_id
4325: AND poc.khr_id = chrb.id
4326: AND poc.khr_id = khrb.id
4327: -- cklee 04/10/2003 never reconcile historical data

Line 5439: l_contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%type;

5435: l_api_version CONSTANT NUMBER := 1.0;
5436: i NUMBER;
5437: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5438: l_action VARCHAR2(40) := p_api_name;
5439: l_contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%type;
5440: l_polv_rec polv_rec_type := p_polv_rec;
5441:
5442: CURSOR l_okl_pol_status_csr(p_pol_id IN NUMBER)
5443: IS