APPS.OKL_UBB_PVT dependencies on OKL_STRM_TYPE_V

Line 77: l_sty_id okl_strm_type_v.id%TYPE;

73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;
75: l_try_id okl_trx_types_tl.id%TYPE;
76: l_clg_id okl_trx_ar_invoices_v.clg_id%TYPE;
77: l_sty_id okl_strm_type_v.id%TYPE;
78: l_first_line CONSTANT NUMBER := 1;
79: l_line_step CONSTANT NUMBER := 1;
80: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
81: l_fin_asset_id NUMBER;

Line 177: SELECT ID FROM okl_strm_type_v WHERE NAME = 'USAGE CHARGE';

173: CURSOR l_try_id_cur IS
174: SELECT ID FROM okl_trx_types_tl WHERE NAME = 'Billing' and LANGUAGE = 'US';
175: /*
176: CURSOR l_sty_id_cur IS
177: SELECT ID FROM okl_strm_type_v WHERE NAME = 'USAGE CHARGE';
178: */
179: BEGIN
180: IF (G_DEBUG_ENABLED = 'Y') THEN
181: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 598: OKL_STRM_TYPE_V STY

594: and cnsld.sel_id in (SELECT SEL.id
595: FROM OKL_STREAMS_V STM,
596: OKL_STRM_ELEMENTS_V SEL,
597: OKC_K_HEADERS_V KHR,
598: OKL_STRM_TYPE_V STY
599: WHERE KHR.id = c_khr_id
600: AND SEL.stream_element_date <= c_transaction_date
601: AND KHR.id = STM.khr_id
602: AND STM.id = SEL.stm_id

Line 636: OKL_STRM_TYPE_V STY

632: SELECT sel.id stream_id,
633: sel.stream_element_date last_sche_bill_date
634: FROM OKL_STREAMS_V STM,
635: OKL_STRM_ELEMENTS_V SEL,
636: OKL_STRM_TYPE_V STY
637: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
638: FROM OKL_STREAMS_V STM,
639: OKL_STRM_ELEMENTS_V SEL,
640: OKC_K_HEADERS_V KHR,

Line 641: OKL_STRM_TYPE_V STY

637: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
638: FROM OKL_STREAMS_V STM,
639: OKL_STRM_ELEMENTS_V SEL,
640: OKC_K_HEADERS_V KHR,
641: OKL_STRM_TYPE_V STY
642: WHERE KHR.id = c_khr_id
643: AND SEL.stream_element_date <= c_transaction_date
644: AND KHR.id = STM.khr_id
645: AND STM.id = SEL.stm_id

Line 891: l_sty_id okl_strm_type_v.id%TYPE;

887: l_first_line CONSTANT NUMBER := 1;
888: l_line_step CONSTANT NUMBER := 1;
889: l_def_no_val CONSTANT NUMBER := -1;
890: l_null_kle_id CONSTANT NUMBER := -2;
891: l_sty_id okl_strm_type_v.id%TYPE;
892:
893: ------------------------------------------------------------
894: -- Declare records: i - insert, u - update, r - result
895: ------------------------------------------------------------

Line 995: SELECT ID FROM okl_strm_type_v WHERE NAME = 'SERVICE FEE';

991: and tai.description = 'OKS Billing')
992: order by chr.contract_number, OKS_LNS.date_billed_from, lns.id;
993: /*
994: CURSOR l_sty_id_cur IS
995: SELECT ID FROM okl_strm_type_v WHERE NAME = 'SERVICE FEE';
996: */
997: BEGIN
998: IF (G_DEBUG_ENABLED = 'Y') THEN
999: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);