APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_K_LINES_B

Line 40: AND (stm.kle_id is not null and EXISTS (SELECT 1 FROM OKC_K_LINES_B CLE

36: WHERE stm.sty_id = sty.id
37: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
38: --AND sty.name IN ('RENT', 'SERVICE AND MAINTENANCE', 'ESTIMATED PERSONAL PROPERTY TAX'))
39: AND sty.stream_type_purpose IN ('RENT', 'SERVICE_PAYMENT', 'ESTIMATED_PROPERTY_TAX', 'FEE_PAYMENT'))
40: AND (stm.kle_id is not null and EXISTS (SELECT 1 FROM OKC_K_LINES_B CLE
41: WHERE cle.dnz_chr_id = oklh.id
42: AND cle.id = stm.kle_id
43: AND cle.sts_code = 'EVERGREEN') OR stm.kle_id IS NULL)
44: GROUP BY oklh.id,