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 3267: FROM okl_k_headers khr,

3263: -- then raise an error
3264: CURSOR l_okl_reject_le_csr(p_khr_id IN NUMBER)
3265: IS
3266: SELECT '1'
3267: FROM okl_k_headers khr,
3268: okl_pools pol
3269: WHERE pol.legal_entity_id <> khr.legal_entity_id
3270: AND pol.id =p_pol_id
3271: AND khr.id = p_khr_id;

Line 4131: okl_k_headers khrb

4127: -- to remove all contents pointing to invalid contracts
4128: SELECT poc.id
4129: FROM okl_pool_contents poc,
4130: okc_k_headers_b chrb,
4131: okl_k_headers khrb
4132: WHERE poc.pol_id = p_pol_id
4133: AND poc.khr_id = chrb.id
4134: AND poc.khr_id = khrb.id
4135: -- cklee 04/10/2003 never reconcile historical data

Line 4316: okl_k_headers khrb

4312: -- to remove all contents pointing to invalid contracts
4313: SELECT poc.id
4314: FROM okl_pool_contents poc,
4315: okc_k_headers_b chrb,
4316: okl_k_headers khrb
4317: WHERE poc.pol_id = p_pol_id
4318: AND poc.khr_id = chrb.id
4319: AND poc.khr_id = khrb.id
4320: -- cklee 04/10/2003 never reconcile historical data

Line 5430: l_contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%type;

5426: l_api_version CONSTANT NUMBER := 1.0;
5427: i NUMBER;
5428: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5429: l_action VARCHAR2(40) := p_api_name;
5430: l_contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%type;
5431: l_polv_rec polv_rec_type := p_polv_rec;
5432:
5433: CURSOR l_okl_pol_status_csr(p_pol_id IN NUMBER)
5434: IS