APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_STRM_TYPE_TL

Line 124: FROM OKL_STRM_TYPE_TL

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

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

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

Line 425: --okl_strm_type_tl sty,

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

Line 454: --okl_strm_type_tl sty

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

Line 8671: --okl_strm_type_tl sty,

8667: CURSOR l_line_amortexp_csr (chrId NUMBER ) IS
8668: SELECT NVL(SUM(sele.amount),0) amount
8669: FROM okl_strm_elements sele,
8670: okl_streams str,
8671: --okl_strm_type_tl sty,
8672: okl_strm_type_v sty,
8673: okl_K_lines_full_v kle,
8674: okc_statuses_b sts
8675: WHERE sele.stm_id = str.id

Line 8698: --okl_strm_type_tl sty

8694: CURSOR l_chr_amortexp_csr (chrId NUMBER) IS
8695: SELECT NVL(SUM(sele.amount),0) amount
8696: FROM okl_strm_elements sele,
8697: okl_streams str,
8698: --okl_strm_type_tl sty
8699: okl_strm_type_v sty
8700: WHERE sele.stm_id = str.id
8701: AND str.sty_id = sty.id
8702: --AND UPPER(sty.name) = 'AMORTIZED EXPENSE'

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

8896: -- rmunjulu EDAT
8897: l_quote_id NUMBER;
8898: l_quote_date DATE;
8899: l_sysdate DATE;
8900: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
8901: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
8902: --06-Dec-2004 PAGARG Bug# 3948473 variable to store investor agreement id
8903: l_inv_agr_id NUMBER;
8904: BEGIN

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

9103:
9104: l_try_rsn OKL_POOL_TRANSACTIONS.TRANSACTION_REASON%TYPE;
9105: l_residual_amount NUMBER := 0;
9106: l_result_amount NUMBER := 0;
9107: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
9108: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
9109:
9110: BEGIN
9111: -- ****************

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

9320: -- rmunjulu EDAT
9321: l_quote_id NUMBER;
9322: l_quote_date DATE;
9323: l_sysdate DATE;
9324: l_sty_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
9325: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
9326: --06-Dec-2004 PAGARG Bug# 3948473 variable to store investor agreement id
9327: l_inv_agr_id NUMBER;
9328: BEGIN