DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 1511: from okl_k_headers_full_v khr,

1507: Select khr.currency_code,
1508: khr.currency_conversion_type,
1509: khr.currency_conversion_date,
1510: khr.currency_conversion_rate
1511: from okl_k_headers_full_v khr,
1512: okc_k_headers_b rbk_chr
1513: where khr.id = rbk_chr.orig_system_id1
1514: and rbk_chr.id = p_rbk_chr_id;
1515:

Line 1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;

1512: okc_k_headers_b rbk_chr
1513: where khr.id = rbk_chr.orig_system_id1
1514: and rbk_chr.id = p_rbk_chr_id;
1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified

Line 1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1513: where khr.id = rbk_chr.orig_system_id1
1514: and rbk_chr.id = p_rbk_chr_id;
1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified
1521:

Line 1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1514: and rbk_chr.id = p_rbk_chr_id;
1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified
1521:
1522:

Line 1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;
1517: l_orig_curr_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1518: l_orig_curr_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1519: l_orig_curr_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1520: --Bug# : 11.5.9 Rebooks - currency can not be modified
1521:
1522:
1523: l_rbk_cpy Varchar2(1) default 'N';

Line 2272: from okl_k_headers_full_v khr

2268: --cursor to get pdt of original contract
2269: Cursor get_pdt_csr(orig_chr_id in number) is
2270: Select khr.pdt_id,
2271: khr.start_date
2272: from okl_k_headers_full_v khr
2273: where id = orig_chr_id;
2274:
2275: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2276: l_Start_date date;

Line 2275: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;

2271: khr.start_date
2272: from okl_k_headers_full_v khr
2273: where id = orig_chr_id;
2274:
2275: l_pdt_id okl_k_headers_full_v.pdt_id%TYPE;
2276: l_Start_date date;
2277: l_is_orig_pdt_old Varchar2(1) default 'N';
2278: l_no_data_found Boolean;
2279: l_pdtv_rec Okl_SetupProducts_Pub.pdtv_rec_type;