APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_STRM_TYPE_V

Line 323: l_stream_type_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%type;

319: x_msg_count NUMBER;
320: x_msg_data VARCHAR2(4000);
321: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
322:
323: l_stream_type_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%type;
324:
325: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
326: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
327:

Line 333: FROM OKL_STRM_TYPE_V sty

329:
330: CURSOR c_stream_type_purpose (p_sty_id number)
331: IS
332: SELECT sty.STREAM_TYPE_PURPOSE
333: FROM OKL_STRM_TYPE_V sty
334: WHERE sty.ID = p_sty_id
335: ;
336:
337: BEGIN

Line 472: FROM OKL_STRM_TYPE_V sty

468:
469: CURSOR c_is_donwpayment_sty (p_sty_id number)
470: IS
471: SELECT sty.STREAM_TYPE_PURPOSE
472: FROM OKL_STRM_TYPE_V sty
473: WHERE sty.ID = p_sty_id
474: ;
475:
476: CURSOR c_is_capitalize (p_asset_id number)

Line 1689: l_stream_type_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%type;

1685: p_pym_tbl IN pym_tbl_type) IS
1686:
1687: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_VR_PAYMENT';
1688: l_api_version CONSTANT NUMBER := 1.0;
1689: l_stream_type_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%type;
1690:
1691: --Added by bkatraga for bug 14111538
1692: i NUMBER := 0;
1693: l_stream_type_name OKL_STRM_TYPE_V.NAME%TYPE;

Line 1693: l_stream_type_name OKL_STRM_TYPE_V.NAME%TYPE;

1689: l_stream_type_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%type;
1690:
1691: --Added by bkatraga for bug 14111538
1692: i NUMBER := 0;
1693: l_stream_type_name OKL_STRM_TYPE_V.NAME%TYPE;
1694:
1695: --Added sty.name by bkatraga for bug 14111538
1696: CURSOR c_stream_type_purpose (p_sty_id number)
1697: IS

Line 1700: FROM OKL_STRM_TYPE_V sty

1696: CURSOR c_stream_type_purpose (p_sty_id number)
1697: IS
1698: SELECT sty.STREAM_TYPE_PURPOSE,
1699: sty.name
1700: FROM OKL_STRM_TYPE_V sty
1701: WHERE sty.ID = p_sty_id;
1702: BEGIN
1703: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1704: -- call START_ACTIVITY to create savepoint, check compatibility