APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_STRM_TYPE_TL

Line 123: FROM OKL_STRM_TYPE_TL

119: AND STR.KLE_ID = p_contract_line_id;
120:
121: CURSOR C_OKL_STRM_TYPE_REC_V IS
122: SELECT ID
123: FROM OKL_STRM_TYPE_TL
124: WHERE NAME = 'INSURANCE RECEIVABLE'
125: AND LANGUAGE = 'US';
126:
127: CURSOR c_monthly_premium (p_contract_id NUMBER,p_contract_line_id NUMBER )

Line 139: l_stm_type_id OKL_STRM_TYPE_TL.ID%TYPE := 0;

135: ls_payment_freq OKL_INS_POLICIES_B.IPF_CODE%TYPE;
136: date_to OKL_INS_POLICIES_B.DATE_TO%TYPE ;
137: date_from OKL_INS_POLICIES_B.DATE_FROM%TYPE ;
138: cancel_date OKL_INS_POLICIES_B.CANCELLATION_DATE%TYPE;
139: l_stm_type_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
140:
141:
142: l_profile_value NUMBER := 0;
143: l_months_to_refund NUMBER := 0;

Line 424: --okl_strm_type_tl sty,

420: SELECT NVL(str.link_hist_stream_id,-1) link_hist_stream_id,
421: NVL(SUM(sele.amount),0) amount
422: FROM okl_strm_elements sele,
423: okl_streams str,
424: --okl_strm_type_tl sty,
425: okl_strm_type_v sty,
426: okl_K_lines_full_v kle,
427: okc_statuses_b sts
428: WHERE sele.stm_id = str.id

Line 453: --okl_strm_type_tl sty

449: CURSOR l_chr_rents_csr (chrId NUMBER ) IS
450: SELECT NVL(SUM(sele.amount),0) amount
451: FROM okl_strm_elements sele,
452: okl_streams str,
453: --okl_strm_type_tl sty
454: okl_strm_type_v sty
455: WHERE sele.stm_id = str.id
456: AND str.sty_id = sty.id
457: --AND UPPER(sty.name) = 'RENT'

Line 473: --okl_strm_type_tl sty,

469: SELECT NVL(str.link_hist_stream_id,-1) link_hist_stream_id,
470: NVL(SUM(sele.amount),0) amount
471: FROM okl_strm_elements sele,
472: okl_streams str,
473: --okl_strm_type_tl sty,
474: okl_strm_type_v sty,
475: okl_K_lines_full_v kle,
476: okc_statuses_b sts
477: WHERE sele.stm_id = str.id

Line 9521: --okl_strm_type_tl sty,

9517: CURSOR l_line_amortexp_csr (chrId NUMBER ) IS
9518: SELECT NVL(SUM(sele.amount),0) amount
9519: FROM okl_strm_elements sele,
9520: okl_streams str,
9521: --okl_strm_type_tl sty,
9522: okl_strm_type_v sty,
9523: okl_K_lines_full_v kle,
9524: okc_statuses_b sts
9525: WHERE sele.stm_id = str.id

Line 9548: --okl_strm_type_tl sty

9544: CURSOR l_chr_amortexp_csr (chrId NUMBER) IS
9545: SELECT NVL(SUM(sele.amount),0) amount
9546: FROM okl_strm_elements sele,
9547: okl_streams str,
9548: --okl_strm_type_tl sty
9549: okl_strm_type_v sty
9550: WHERE sele.stm_id = str.id
9551: AND str.sty_id = sty.id
9552: --AND UPPER(sty.name) = 'AMORTIZED EXPENSE'

Line 9752: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;

9748: -- rmunjulu EDAT
9749: l_quote_id NUMBER;
9750: l_quote_date DATE;
9751: l_sysdate DATE;
9752: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
9753: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
9754: --06-Dec-2004 PAGARG Bug# 3948473 variable to store investor agreement id
9755: l_inv_agr_id NUMBER;
9756: BEGIN

Line 9959: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;

9955:
9956: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
9957: l_residual_amount NUMBER := 0;
9958: l_result_amount NUMBER := 0;
9959: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
9960: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
9961:
9962: BEGIN
9963: -- ****************

Line 10176: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;

10172: -- rmunjulu EDAT
10173: l_quote_id NUMBER;
10174: l_quote_date DATE;
10175: l_sysdate DATE;
10176: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
10177: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
10178: --06-Dec-2004 PAGARG Bug# 3948473 variable to store investor agreement id
10179: l_inv_agr_id NUMBER;
10180: BEGIN