APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_STRM_TYPE_TL

Line 1102: from OKL_STRM_TYPE_TL

1098:
1099:
1100: CURSOR C_OKL_STRM_TYPE_CRE_V IS
1101: select ID
1102: from OKL_STRM_TYPE_TL
1103: where NAME = 'INSURANCE REFUND'
1104: AND LANGUAGE = 'US';
1105:
1106:

Line 2003: from OKL_STRM_TYPE_TL

1999:
2000:
2001: CURSOR c_okl_strem_type_rec(ls_strm_type VARCHAR2) IS
2002: select ID
2003: from OKL_STRM_TYPE_TL
2004: where NAME = ls_strm_type
2005: AND LANGUAGE = 'US';
2006:
2007: p_stmv_rec Okl_Streams_Pub.stmv_rec_type;

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

2759: -- Calculate customer Refund
2760: -----------------------------------------------------------
2761: FUNCTION get_cust_refund(p_ipyv_rec IN ipyv_rec_type,
2762: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2763: l_stm_type_rcvbl_id OKL_STRM_TYPE_TL.ID%TYPE := 0;
2764: l_no_of_rec NUMBER := 0;
2765: l_monthly_premium NUMBER;
2766: l_freq_factor NUMBER;
2767: l_vld_cncl_dt VARCHAR2(1) := '?';

Line 2790: FROM OKL_STRM_TYPE_TL

2786: AND STR.KHR_ID = c_contract_id
2787: AND STR.KLE_ID = c_contract_line_id;
2788: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
2789: SELECT ID
2790: FROM OKL_STRM_TYPE_TL
2791: WHERE NAME = ls_stm_code
2792: AND LANGUAGE = 'US';
2793: BEGIN
2794: l_ipyv_rec := p_ipyv_rec;

Line 5986: from OKL_STRM_TYPE_TL

5982:
5983:
5984: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
5985: select ID
5986: from OKL_STRM_TYPE_TL
5987: where NAME = ls_stm_code
5988: AND LANGUAGE = 'US';
5989:
5990:

Line 7037: from OKL_STRM_TYPE_TL

7033: l_tai_id NUMBER ;
7034:
7035: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
7036: select ID
7037: from OKL_STRM_TYPE_TL
7038: where NAME = ls_stm_code
7039: AND LANGUAGE = 'US';
7040:
7041: