DBA Data[Home] [Help]

APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_TXL_CNTRCT_LNS

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 483: OKL_TXL_CNTRCT_LNS txl

479: OKL_K_HEADERS khr,
480: OKC_K_HEADERS_B chr,
481: OKL_PRODUCTS pdt,
482: OKL_TRX_CONTRACTS trx,
483: OKL_TXL_CNTRCT_LNS txl
484: WHERE chr.id = khr.id
485: AND pdt.id = khr.pdt_id
486: AND khr.multi_gaap_yn = 'Y'
487: AND khr.id = trx.khr_id