APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_K_HEADERS_FULL_V

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: CURSOR get_sty_id_csr
545: (p_pdt_id number,

Line 1199: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;

1195: /* variables */
1196: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_SEC_REP_TRX';
1197: l_api_version CONSTANT NUMBER := 1.0;
1198: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1199: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1200: l_sysdate DATE := SYSDATE;
1201: l_reversal_date DATE;
1202: l_COUNT NUMBER :=0;
1203: /* record and table structure variables */