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 207: SELECT ID FROM okl_strm_type_v WHERE NAME = 'USAGE CHARGE';

203: CURSOR l_try_id_cur IS
204: SELECT ID FROM okl_trx_types_tl WHERE NAME = 'Billing' and LANGUAGE = 'US';
205: /*
206: CURSOR l_sty_id_cur IS
207: SELECT ID FROM okl_strm_type_v WHERE NAME = 'USAGE CHARGE';
208: */
209: BEGIN
210: IF (G_DEBUG_ENABLED = 'Y') THEN
211: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 685: OKL_STRM_TYPE_V STY

681: and cnsld.sel_id in (SELECT SEL.id
682: FROM OKL_STREAMS_V STM,
683: OKL_STRM_ELEMENTS_V SEL,
684: OKC_K_HEADERS_V KHR,
685: OKL_STRM_TYPE_V STY
686: WHERE KHR.id = c_khr_id
687: AND SEL.stream_element_date <= c_transaction_date
688: AND KHR.id = STM.khr_id
689: AND STM.id = SEL.stm_id

Line 723: OKL_STRM_TYPE_V STY

719: SELECT sel.id stream_id,
720: sel.stream_element_date last_sche_bill_date
721: FROM OKL_STREAMS_V STM,
722: OKL_STRM_ELEMENTS_V SEL,
723: OKL_STRM_TYPE_V STY
724: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
725: FROM OKL_STREAMS_V STM,
726: OKL_STRM_ELEMENTS_V SEL,
727: OKC_K_HEADERS_V KHR,

Line 728: OKL_STRM_TYPE_V STY

724: WHERE sel.stream_element_date = (SELECT max(SEL.stream_element_date) last_sche_bill_date
725: FROM OKL_STREAMS_V STM,
726: OKL_STRM_ELEMENTS_V SEL,
727: OKC_K_HEADERS_V KHR,
728: OKL_STRM_TYPE_V STY
729: WHERE KHR.id = c_khr_id
730: AND SEL.stream_element_date <= c_transaction_date
731: AND KHR.id = STM.khr_id
732: AND STM.id = SEL.stm_id

Line 978: l_sty_id okl_strm_type_v.id%TYPE;

974: l_first_line CONSTANT NUMBER := 1;
975: l_line_step CONSTANT NUMBER := 1;
976: l_def_no_val CONSTANT NUMBER := -1;
977: l_null_kle_id CONSTANT NUMBER := -2;
978: l_sty_id okl_strm_type_v.id%TYPE;
979:
980: ------------------------------------------------------------
981: -- Declare records: i - insert, u - update, r - result
982: ------------------------------------------------------------

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

1078: and tai.description = 'OKS Billing')
1079: order by chr.contract_number, OKS_LNS.date_billed_from, lns.id;
1080: /*
1081: CURSOR l_sty_id_cur IS
1082: SELECT ID FROM okl_strm_type_v WHERE NAME = 'SERVICE FEE';
1083: */
1084: BEGIN
1085: IF (G_DEBUG_ENABLED = 'Y') THEN
1086: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);