APPS.OKL_LTE_CHRG_PVT dependencies on OKL_STRM_TYPE_B

Line 126: ,okl_strm_type_b stb --For bug 7356486

122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm
124: ,okc_rules_b rul_hld
125: ,okl_late_policies_v lte
126: ,okl_strm_type_b stb --For bug 7356486
127: where lpt.invoice_id=lpt1.invoice_id
128: and lpt.pay_sch_class = 'INV'
129: AND lpt.STATUS = 'OP'
130: and nvl(lpt1.late_charge_ass_yn, 'N') = 'N'

Line 177: ,OKL_STRM_TYPE_B SM

173: ,OKL_CNSLD_AR_STRMS_B ST
174: ,OKL_CNSLD_AR_HDRS_B HD
175: ,OKC_K_HEADERS_ALL_B CN
176: ,OKL_CNSLD_AR_LINES_B LN
177: ,OKL_STRM_TYPE_B SM
178: ,okl_k_headers_full_v khr
179: ,okc_rule_groups_b rgp
180: ,okc_rules_b rul
181: ,okc_rules_b rul_exm

Line 340: OKL_STRM_TYPE_B SM

336: OKL_CNSLD_AR_STRMS_B ST,
337: OKL_CNSLD_AR_HDRS_B HD,
338: OKC_K_HEADERS_ALL_B CN,
339: OKL_CNSLD_AR_LINES_B LN,
340: OKL_STRM_TYPE_B SM
341: WHERE PS.CLASS IN ('INV', 'CM')
342: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
343: AND CN.ID = ST.KHR_ID
344: AND LN.ID = ST.LLN_ID

Line 365: OKL_STRM_TYPE_B SM

361: OKL_CNSLD_AR_STRMS_B ST,
362: OKL_CNSLD_AR_HDRS_B HD,
363: OKC_K_HEADERS_ALL_B CN,
364: OKL_CNSLD_AR_LINES_B LN,
365: OKL_STRM_TYPE_B SM
366: WHERE PS.CLASS IN ('INV', 'CM')
367: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
368: AND CN.ID = ST.KHR_ID
369: AND LN.ID = ST.LLN_ID

Line 599: ,okl_strm_type_b sty

595:
596: CURSOR c_strm_purpose(cp_stream_id IN NUMBER) IS
597: SELECT sty.stream_type_purpose
598: FROM okl_bpd_ar_inv_lines_v arl
599: ,okl_strm_type_b sty
600: WHERE arl.id = cp_stream_id
601: AND arl.sty_id = sty.id;
602:
603: ------------------------------------------------------------