APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_TRX_CONTRACTS

Line 281: l_currency_code OKL_TRX_CONTRACTS.currency_code%TYPE;

277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%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';

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 357: OKL_TRX_CONTRACTS trx,

353: SELECT fad.asset_category_id,
354: decode(trx.accrual_activity,'NON-ACCRUAL','NON-ACCRUAL','ACCRUAL') accrual_activity,
355: SUM(fds.deprn_amount) deprn_amount
356: FROM
357: OKL_TRX_CONTRACTS trx,
358: OKC_K_ITEMS cli,
359: OKC_K_LINES_B cle,
360: OKC_LINE_STYLES_B cls,
361: FA_BOOKS fab,

Line 482: OKL_TRX_CONTRACTS trx,

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
485: AND pdt.id = khr.pdt_id
486: AND khr.multi_gaap_yn = 'Y'

Line 650: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;

646:
647: DECLARE
648: -- Declare local variables which need to be re-initialized to null for each contract
649: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
650: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;
651: l_deprn_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;
652: l_record_status VARCHAR2(10);
653: l_record_status2 VARCHAR2(10);
654: l_record_status3 VARCHAR2(10);

Line 651: l_deprn_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;

647: DECLARE
648: -- Declare local variables which need to be re-initialized to null for each contract
649: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
650: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;
651: l_deprn_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;
652: l_record_status VARCHAR2(10);
653: l_record_status2 VARCHAR2(10);
654: l_record_status3 VARCHAR2(10);
655: l_contract_verified VARCHAR2(3);