APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_K_HEADERS

Line 39: FROM okc_k_headers_b a, okl_k_headers b

35:
36: -- Get the financial product of the contract
37: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
38: SELECT a.start_date, a.contract_number, b.pdt_id
39: FROM okc_k_headers_b a, okl_k_headers b
40: WHERE a.id = b.id
41: AND a.id = cp_khr_id;
42:
43: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 151: FROM OKL_K_HEADERS KHR

147: l_is_mg_enabled VARCHAR2(1) := 'N';
148:
149: CURSOR is_mg_enabled IS
150: SELECT NVL(KHR.MULTI_GAAP_YN,'N')
151: FROM OKL_K_HEADERS KHR
152: WHERE ID = p_khr_id;
153:
154: BEGIN
155: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 528: FROM okl_k_headers_full_v

524: SELECT currency_code,
525: currency_conversion_rate,
526: currency_conversion_type,
527: currency_conversion_date
528: FROM okl_k_headers_full_v
529: WHERE id = l_pri_trx_tclv_rec.khr_id ;
530:
531: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := null;
532: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := null;

Line 531: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := null;

527: currency_conversion_date
528: FROM okl_k_headers_full_v
529: WHERE id = l_pri_trx_tclv_rec.khr_id ;
530:
531: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := null;
532: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := null;
533: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := null;
534: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE := null;
535:

Line 532: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := null;

528: FROM okl_k_headers_full_v
529: WHERE id = l_pri_trx_tclv_rec.khr_id ;
530:
531: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := null;
532: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := null;
533: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := null;
534: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE := null;
535:
536: l_sty_id number := null;

Line 533: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := null;

529: WHERE id = l_pri_trx_tclv_rec.khr_id ;
530:
531: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := null;
532: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := null;
533: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := null;
534: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE := null;
535:
536: l_sty_id number := null;
537: l_contract_start_date date :=null;

Line 541: FROM okl_k_headers_full_v

537: l_contract_start_date date :=null;
538:
539: CURSOR cntrct_csr (p_khr_id NUMBER)IS
540: SELECT start_date
541: FROM okl_k_headers_full_v
542: WHERE id = p_khr_id;
543:
544: --Bug# 8969376
545: CURSOR get_primary_sty_id_csr

Line 1221: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;

1217: /* variables */
1218: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_SEC_REP_TRX';
1219: l_api_version CONSTANT NUMBER := 1.0;
1220: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1221: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1222: l_sysdate DATE := SYSDATE;
1223: l_reversal_date DATE;
1224: l_COUNT NUMBER :=0;
1225: /* record and table structure variables */