APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_STRM_TYPE_TL

Line 336: FROM okl_trx_contracts trx, okl_txl_cntrct_lns txl, okl_strm_type_tl stytl

332: CURSOR accrual_trx_csr(p_khr_id NUMBER,p_date_from DATE,p_date_to DATE) IS
333: SELECT stytl.name stream_type,
334: decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL') accrual_activity,
335: sum(txl.amount) total_amount
336: FROM okl_trx_contracts trx, okl_txl_cntrct_lns txl, okl_strm_type_tl stytl
337: WHERE trx.khr_id = p_khr_id
338: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
339: AND trx.tsu_code = 'PROCESSED'
340: --rkuttiya added for 12.1.1 Multi GAAP

Line 407: FROM OKL_STRM_TYPE_TL stytl,

403: SELECT stytl.name stream_type,
404: sty.accrual_yn,
405: chr.currency_code,
406: ABS(SUM(ste.amount)) total_amount
407: FROM OKL_STRM_TYPE_TL stytl,
408: OKL_STRM_TYPE_B sty,
409: OKL_STREAMS stm,
410: OKL_STRM_ELEMENTS ste,
411: OKL_PROD_STRM_TYPES psty,

Line 478: FROM OKL_STRM_TYPE_TL stytl,

474: chr.currency_code,
475: stytl.name stream_type,
476: decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL') accrual_activity,
477: SUM(txl.amount) total_amount
478: FROM OKL_STRM_TYPE_TL stytl,
479: OKL_K_HEADERS khr,
480: OKC_K_HEADERS_B chr,
481: OKL_PRODUCTS pdt,
482: OKL_TRX_CONTRACTS trx,