DBA Data[Home] [Help]

APPS.OKL_CONTRACT_INFO dependencies on OKC_K_HEADERS_TL

Line 94: SELECT SUBSTR(description,1,240) FROM okc_k_headers_tl

90: RETURN VARCHAR2
91: IS
92: -- Get the vendor Program description
93: CURSOR vendor_program_csr(p_contract_id NUMBER) IS
94: SELECT SUBSTR(description,1,240) FROM okc_k_headers_tl
95: WHERE ID =
96: ( SELECT khr_id
97: FROM okl_k_headers
98: WHERE id = p_contract_id);