APPS.OKL_CONTRACT_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 1543: from okl_k_headers_full_v khr,

1539: Select khr.currency_code,
1540: khr.currency_conversion_type,
1541: khr.currency_conversion_date,
1542: khr.currency_conversion_rate
1543: from okl_k_headers_full_v khr,
1544: okc_k_headers_b rbk_chr
1545: where khr.id = rbk_chr.orig_system_id1
1546: and rbk_chr.id = p_rbk_chr_id;
1547:

Line 1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;

1544: okc_k_headers_b rbk_chr
1545: where khr.id = rbk_chr.orig_system_id1
1546: and rbk_chr.id = p_rbk_chr_id;
1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified

Line 1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1545: where khr.id = rbk_chr.orig_system_id1
1546: and rbk_chr.id = p_rbk_chr_id;
1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified
1553:

Line 1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1546: and rbk_chr.id = p_rbk_chr_id;
1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified
1553:
1554:

Line 1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1549: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1550: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1551: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1552: --Bug# : 11.5.9 Rebooks - currency can not be modified
1553:
1554:
1555: l_rbk_cpy Varchar2(1) default 'N';

Line 2339: from okl_k_headers_full_v khr

2335: --cursor to get pdt of original contract
2336: Cursor get_pdt_csr(orig_chr_id in number) is
2337: Select khr.pdt_id,
2338: khr.start_date
2339: from okl_k_headers_full_v khr
2340: where id = orig_chr_id;
2341:
2342: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2343: l_Start_date date;

Line 2342: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;

2338: khr.start_date
2339: from okl_k_headers_full_v khr
2340: where id = orig_chr_id;
2341:
2342: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2343: l_Start_date date;
2344: l_is_orig_pdt_old Varchar2(1) default 'N';
2345: l_no_data_found Boolean;
2346: l_pdtv_rec Okl_SetupProducts_Pub.pdtv_rec_type;