APPS.OKL_QA_SECURITIZATION dependencies on OKC_K_HEADERS_B

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;