APPS.OKL_LOSS_PROV_PVT dependencies on OKL_STRM_TYPE_V

Line 1060: ,sty_id OKL_STRM_TYPE_V.ID%TYPE

1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
1057:
1058: TYPE pool_contents_rec_type is RECORD(
1059: lease_contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1060: ,sty_id OKL_STRM_TYPE_V.ID%TYPE
1061: ,sty_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE
1062: ,streams_to_date OKL_POOL_CONTENTS_V.streams_to_date%TYPE);
1063:
1064: TYPE pdt_contracts_tbl_type IS TABLE OF pdt_contracts_rec_type INDEX BY BINARY_INTEGER;

Line 1061: ,sty_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE

1057:
1058: TYPE pool_contents_rec_type is RECORD(
1059: lease_contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1060: ,sty_id OKL_STRM_TYPE_V.ID%TYPE
1061: ,sty_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE
1062: ,streams_to_date OKL_POOL_CONTENTS_V.streams_to_date%TYPE);
1063:
1064: TYPE pdt_contracts_tbl_type IS TABLE OF pdt_contracts_rec_type INDEX BY BINARY_INTEGER;
1065: TYPE pool_contents_tbl_type IS TABLE OF pool_contents_rec_type INDEX BY BINARY_INTEGER;

Line 1532: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;

1528: l_loss_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1529: l_trx_header_total OKL_TRX_CONTRACTS.AMOUNT%TYPE := 0;
1530: l_converted_net_book_value NUMBER;
1531: l_sty_id OKL_TXL_CNTRCT_LNS.STY_ID%TYPE; --:= to_number(p_sty_id);
1532: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
1533:
1534:
1535: -- creating variable required by okl_accounting_util.convert_to_contract_currency
1536: -- these variables not used anywhere.

Line 2312: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;

2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
2310: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
2311: l_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE;
2312: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
2313: l_sysdate DATE := SYSDATE;
2314: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
2315: l_period_start_date DATE;
2316: l_period_end_date DATE;