APPS.OKL_QA_SECURITIZATION dependencies on OKL_K_HEADERS

Line 877: FROM okl_pool_contents a, okc_k_headers_b b,okl_k_headers c, okl_pools d

873: SELECT a.khr_id,
874: decode(c.securitization_type, 'SALE','SECURITIZATION','LOAN','SYNDICATION',
875: 'SECURITIZATION','SECURITIZATION','SYNDICATION','SYNDICATION') securitization_type,
876: b.contract_number
877: FROM okl_pool_contents a, okc_k_headers_b b,okl_k_headers c, okl_pools d
878: WHERE a.khr_id = p_khr_id
879: AND a.pol_id=d.id
880: AND d.khr_id= c.id
881: AND b.id=c.id;

Line 885: l_previous_type okl_k_headers.securitization_type%TYPE;

881: AND b.id=c.id;
882:
883: l_khr_id number;
884:
885: l_previous_type okl_k_headers.securitization_type%TYPE;
886: l_previous_khr_id NUMBER;
887:
888: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
889: l_token VARCHAR2(2000);