APPS.OKL_MULTI_GAAP_PVT dependencies on OKC_K_HEADERS_B

Line 284: l_contract_currency OKC_K_HEADERS_B.currency_code%TYPE;

280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
281: l_currency_code OKL_TRX_CONTRACTS.currency_code%TYPE;
282: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
283: l_book_type_code OKL_TXD_ASSETS_V.tax_book%TYPE;
284: l_contract_currency OKC_K_HEADERS_B.currency_code%TYPE;
285: l_api_name CONSTANT VARCHAR2(2000) := 'MULTI_GAAP_SUPPORT';
286: l_api_version CONSTANT NUMBER := 1.0;
287: p_api_version CONSTANT NUMBER := 1.0;
288: l_sob_name VARCHAR2(2000);

Line 322: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr, OKL_PRODUCTS pdt

318: pdt.name pdt_name,
319: pdt.reporting_pdt_id,
320: khr.deal_type,
321: chr.currency_code
322: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr, OKL_PRODUCTS pdt
323: WHERE chr.id = khr.id
324: AND chr.scs_code = 'LEASE'
325: AND chr.sts_code IN ('BOOKED','EVERGREEN') -- Bug 3448049. removed approved and under revision statuses
326: AND khr.pdt_id = pdt.id

Line 413: OKC_K_HEADERS_B chr,

409: OKL_STREAMS stm,
410: OKL_STRM_ELEMENTS ste,
411: OKL_PROD_STRM_TYPES psty,
412: OKL_K_HEADERS khr,
413: OKC_K_HEADERS_B chr,
414: OKL_PRODUCTS pdt
415: WHERE stm.khr_id = p_khr_id
416: AND khr.id = chr.id
417: AND khr.id = stm.khr_id

Line 480: OKC_K_HEADERS_B chr,

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,
483: OKL_TXL_CNTRCT_LNS txl
484: WHERE chr.id = khr.id