1007: IS
1008: SELECT 1
1009: FROM OKC_K_HEADERS_B KHR,
1010: OKC_K_LINES_B CLE, 1011: OKC_LINE_STYLES_B LSE 1012: WHERE CLE.CHR_ID = KHR.ID
1013: AND KHR.ID = p_khr_id
1014: AND CLE.LSE_ID = LSE.ID
1015: AND LSE.LTY_CODE IN ('SOLD_SERVICE','LINK_SERV_ASSET');