DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_PVT dependencies on OKL_K_HEADERS

Line 353: FROM okl_k_headers khr

349:
350: --Check if Vendor program is attached to the Lease contract
351: CURSOR l_khr_csr(p_id NUMBER) IS
352: SELECT khr.khr_id
353: FROM okl_k_headers khr
354: WHERE khr.id = p_id;
355:
356: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_repurchase_agreement';
357: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 658: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;

654:
655: --SECHAWLA Bug # 2667636 : new declarations
656: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
657: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
658: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
659: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
660: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
661: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
662: lx_converted_amount NUMBER;

Line 659: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

655: --SECHAWLA Bug # 2667636 : new declarations
656: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
657: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
658: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
659: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
660: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
661: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
662: lx_converted_amount NUMBER;
663: l_sysdate DATE;

Line 660: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

656: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
657: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
658: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
659: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
660: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
661: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
662: lx_converted_amount NUMBER;
663: l_sysdate DATE;
664:

Line 661: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

657: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
658: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
659: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
660: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
661: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
662: lx_converted_amount NUMBER;
663: l_sysdate DATE;
664:
665: -- This cursor is used to get contract ID for a given financial asset line

Line 691: FROM okl_k_headers

687:
688: -- RRAVIKIR Legal Entity Changes
689: CURSOR fetch_legal_entity(p_khr_id NUMBER) IS
690: SELECT legal_entity_id
691: FROM okl_k_headers
692: WHERE id = p_khr_id;
693:
694: l_legal_entity_id NUMBER;
695: -- Legal Entity Changes

Line 1673: FROM okl_k_headers

1669:
1670: -- RRAVIKIR Legal Entity Changes
1671: CURSOR fetch_legal_entity(p_khr_id NUMBER) IS
1672: SELECT legal_entity_id, deal_type --6674730
1673: FROM okl_k_headers
1674: WHERE id = p_khr_id;
1675:
1676: l_legal_entity_id NUMBER;
1677: -- Legal Entity Changes