DBA Data[Home] [Help]

APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_STRM_TYPE_B

Line 118: FROM OKL_STRM_TYPE_B sty

114: FROM ra_customer_trx_lines_all ractrl,
115: okc_k_headers_b chr
116: WHERE chr.contract_number = ractrl.interface_line_attribute6
117: AND EXISTS(SELECT sty.code
118: FROM OKL_STRM_TYPE_B sty
119: WHERE sty.stream_type_purpose = p_stream_purpose
120: AND sty.code = ractrl.interface_line_attribute9)
121: GROUP BY chr.id;
122:

Line 1743: FROM OKL_STRM_TYPE_B sty

1739: and chr.id = mla_g1.dnz_chr_id
1740: and chr.scs_code = 'LEASE'
1741: )
1742: AND EXISTS(SELECT sty.code
1743: FROM OKL_STRM_TYPE_B sty
1744: WHERE sty.stream_type_purpose = p_stream_purpose
1745: AND sty.code = ractrl.interface_line_attribute9);
1746:
1747: