DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_STRM_TYPE_TL

Line 110: --SELECT id FROM OKL_STRM_TYPE_TL

106:
107: -- SGIYER
108: -- Commenting Cursor below as not needed. user Defined Streams Project.
109: --CURSOR get_sty_id_csr IS
110: --SELECT id FROM OKL_STRM_TYPE_TL
111: --WHERE name = l_sty_name
112: --AND language = 'US';
113:
114: CURSOR get_unb_rec_csr(p_sty_id NUMBER) IS

Line 904: OKL_STRM_TYPE_TL stytl,

900: ste.id stream_element_id,
901: ste.amount,
902: stm.kle_id
903: FROM OKL_STRM_TYPE_B sty,
904: OKL_STRM_TYPE_TL stytl,
905: --OKL_STREAMS stm,
906: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
907: OKL_STRM_ELEMENTS ste,
908: OKL_PROD_STRM_TYPES psty,

Line 937: OKL_STRM_TYPE_TL stytl,

933: ste.id stream_element_id,
934: ste.amount,
935: stm.kle_id
936: FROM OKL_STRM_TYPE_B sty,
937: OKL_STRM_TYPE_TL stytl,
938: --OKL_STREAMS stm,
939: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
940: OKL_STRM_ELEMENTS ste,
941: OKL_PROD_STRM_TYPES psty,

Line 5332: --FROM okl_strm_type_tl

5328: -- Cursor to select the stream type id for the streams being accrued in case of variable interest rate contracts
5329: --SGIYER. Commenting below. Not needed for User Defined Streams Project.
5330: --CURSOR sty_id_csr(p_sty_name VARCHAR2) IS
5331: --SELECT id
5332: --FROM okl_strm_type_tl
5333: --WHERE name = p_sty_name
5334: --AND language = 'US';
5335:
5336: -- Cursor to select currency conversion information