APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_K_LINES_B

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

45: WHERE stm.sty_id = sty.id
46: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
47: --AND sty.name IN ('RENT', 'SERVICE AND MAINTENANCE', 'ESTIMATED PERSONAL PROPERTY TAX'))
48: AND sty.stream_type_purpose IN ('RENT', 'SERVICE_PAYMENT', 'ESTIMATED_PROPERTY_TAX', 'FEE_PAYMENT'))
49: AND (stm.kle_id is not null and EXISTS (SELECT 1 FROM OKC_K_LINES_B CLE
50: WHERE cle.dnz_chr_id = oklh.id
51: AND cle.id = stm.kle_id
52: AND cle.sts_code = 'EVERGREEN') OR stm.kle_id IS NULL)
53: GROUP BY oklh.id,

Line 83: FROM OKC_K_LINES_B CLE

79: AND EXISTS (SELECT 1 FROM okl_strm_type_v sty
80: WHERE stm.sty_id = sty.id
81: AND sty.stream_type_purpose IN ('RENT', 'SERVICE_PAYMENT', 'ESTIMATED_PROPERTY_TAX', 'FEE_PAYMENT'))
82: AND (stm.kle_id is not null and EXISTS ( SELECT 1
83: FROM OKC_K_LINES_B CLE
84: WHERE cle.dnz_chr_id = oklh.id
85: AND cle.id = stm.kle_id
86: AND cle.sts_code = 'EVERGREEN'
87: )