APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_STRM_TYPE_TL

Line 1121: from OKL_STRM_TYPE_TL

1117:
1118:
1119: CURSOR C_OKL_STRM_TYPE_CRE_V IS
1120: select ID
1121: from OKL_STRM_TYPE_TL
1122: where NAME = 'INSURANCE REFUND'
1123: AND LANGUAGE = 'US';
1124:
1125:

Line 2022: from OKL_STRM_TYPE_TL

2018:
2019:
2020: CURSOR c_okl_strem_type_rec(ls_strm_type VARCHAR2) IS
2021: select ID
2022: from OKL_STRM_TYPE_TL
2023: where NAME = ls_strm_type
2024: AND LANGUAGE = 'US';
2025:
2026: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

Line 2782: l_stm_type_rcvbl_id OKL_STRM_TYPE_TL.ID%TYPE := 0;

2778: -- Calculate customer Refund
2779: -----------------------------------------------------------
2780: FUNCTION get_cust_refund(p_ipyv_rec IN ipyv_rec_type,
2781: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2782: l_stm_type_rcvbl_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
2783: l_no_of_rec NUMBER := 0;
2784: l_monthly_premium NUMBER;
2785: l_freq_factor NUMBER;
2786: l_vld_cncl_dt VARCHAR2(1) := '?';

Line 2809: FROM OKL_STRM_TYPE_TL

2805: AND STR.KHR_ID = c_contract_id
2806: AND STR.KLE_ID = c_contract_line_id;
2807: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
2808: SELECT ID
2809: FROM OKL_STRM_TYPE_TL
2810: WHERE NAME = ls_stm_code
2811: AND LANGUAGE = 'US';
2812: BEGIN
2813: l_ipyv_rec := p_ipyv_rec;

Line 5979: from OKL_STRM_TYPE_TL

5975:
5976:
5977: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
5978: select ID
5979: from OKL_STRM_TYPE_TL
5980: where NAME = ls_stm_code
5981: AND LANGUAGE = 'US';
5982:
5983:

Line 7030: from OKL_STRM_TYPE_TL

7026: l_tai_id NUMBER ;
7027:
7028: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
7029: select ID
7030: from OKL_STRM_TYPE_TL
7031: where NAME = ls_stm_code
7032: AND LANGUAGE = 'US';
7033:
7034: