DBA Data[Home] [Help]

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: --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 */