APPS.OKL_CURE_RECON_PVT dependencies on OKL_K_HEADERS

Line 305: from okl_cure_amounts a, okl_k_headers b

301: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
302: || l_api_name;
303: Cursor c_get_obj_ver (p_cam_id IN NUMBER) is
304: select a.object_version_number,a.cure_amount,b.khr_id
305: from okl_cure_amounts a, okl_k_headers b
306: where cure_amount_id =p_cam_id
307: and a.chr_id =b.id;
308:
309: lp_camv_rec OKL_cam_pvt.camv_rec_type;

Line 313: l_khr_id okl_k_headers.khr_id%TYPE;

309: lp_camv_rec OKL_cam_pvt.camv_rec_type;
310: xp_camv_rec OKL_cam_pvt.camv_rec_type;
311: l_short_fund_amount okl_cure_amounts.short_fund_amount%TYPE;
312: l_cure_amount okl_cure_amounts.cure_amount%TYPE;
313: l_khr_id okl_k_headers.khr_id%TYPE;
314:
315: l_rule_name VARCHAR2(200);
316: l_rule_value VARCHAR2(2000);
317: l_id1 VARCHAR2(40);

Line 996: select khr_id from okl_k_headers where id= p_contract_id;

992: -- End
993:
994:
995: cursor c_program_id (p_contract_id IN NUMBER ) IS
996: select khr_id from okl_k_headers where id= p_contract_id;
997:
998:
999: l_program_id okl_k_headers.khr_id%TYPE;
1000:

Line 999: l_program_id okl_k_headers.khr_id%TYPE;

995: cursor c_program_id (p_contract_id IN NUMBER ) IS
996: select khr_id from okl_k_headers where id= p_contract_id;
997:
998:
999: l_program_id okl_k_headers.khr_id%TYPE;
1000:
1001: l_id1 VARCHAR2(40) :=NULL;
1002: l_id2 VARCHAR2(200) :=NULL;
1003: l_rule_value VARCHAR2(2000):=NULL;

Line 2032: FROM okl_k_headers

2028: IS
2029: SELECT currency_conversion_type,
2030: currency_conversion_rate,
2031: currency_conversion_date
2032: FROM okl_k_headers
2033: WHERE id = l_khr_id;
2034:
2035: l_functional_currency okl_trx_contracts.currency_code%TYPE;
2036: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

Line 2036: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

2032: FROM okl_k_headers
2033: WHERE id = l_khr_id;
2034:
2035: l_functional_currency okl_trx_contracts.currency_code%TYPE;
2036: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
2037: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
2038: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
2039: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;
2040:

Line 2037: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;

2033: WHERE id = l_khr_id;
2034:
2035: l_functional_currency okl_trx_contracts.currency_code%TYPE;
2036: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
2037: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
2038: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
2039: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;
2040:
2041: next_row integer;

Line 2038: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;

2034:
2035: l_functional_currency okl_trx_contracts.currency_code%TYPE;
2036: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
2037: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
2038: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
2039: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;
2040:
2041: next_row integer;
2042:

Line 2072: FROM okl_k_headers okl,

2068: IS
2069: SELECT okl.pdt_id
2070: ,okl.id
2071: ,okc.scs_code -- Bug# 4622198
2072: FROM okl_k_headers okl,
2073: okl_cure_amounts cam,
2074: okc_k_headers_b okc -- Bug# 4622198
2075: WHERE okc.id = okl.id -- Bug# 4622198
2076: and okl.id = cam.chr_id