APPS.OKL_TXD_ASSETS_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 120: FROM okl_k_headers_full_v h,

116: CURSOR header_curr_csr(p_tal_id OKL_TXD_ASSETS_V.TAL_ID%TYPE) IS
117: SELECT h.currency_code,
118: h.currency_conversion_type,
119: h.currency_conversion_date
120: FROM okl_k_headers_full_v h,
121: okl_txl_assets_v txl
122: WHERE h.id = txl.dnz_khr_id
123: AND txl.id = p_tal_id;
124:

Line 148: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

144: * sjalasut added cursor to derive the contract header id and contract line id. END
145: *
146: */
147:
148: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
149: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
150: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
151:
152: --Bug# 4959361

Line 149: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

145: *
146: */
147:
148: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
149: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
150: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
151:
152: --Bug# 4959361
153: CURSOR l_tal_csr(p_tal_id IN NUMBER) IS

Line 150: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

146: */
147:
148: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
149: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
150: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
151:
152: --Bug# 4959361
153: CURSOR l_tal_csr(p_tal_id IN NUMBER) IS
154: SELECT kle_id

Line 603: FROM okl_k_headers_full_v h,

599: CURSOR header_curr_csr(p_txd_id OKL_TXD_ASSETS_V.ID%TYPE) IS
600: SELECT h.currency_code,
601: h.currency_conversion_type,
602: h.currency_conversion_date
603: FROM okl_k_headers_full_v h,
604: okl_txl_assets_v txl,
605: okl_txd_assets_v txd
606: WHERE h.id = txl.dnz_khr_id
607: AND txl.id = txd.tal_id

Line 610: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

606: WHERE h.id = txl.dnz_khr_id
607: AND txl.id = txd.tal_id
608: AND txd.id = p_txd_id;
609:
610: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
611: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
612: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
613:
614: --Bug# 4959361

Line 611: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

607: AND txl.id = txd.tal_id
608: AND txd.id = p_txd_id;
609:
610: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
611: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
612: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
613:
614: --Bug# 4959361
615: CURSOR l_tal_csr(p_tal_id IN NUMBER) IS

Line 612: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

608: AND txd.id = p_txd_id;
609:
610: l_header_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
611: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
612: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
613:
614: --Bug# 4959361
615: CURSOR l_tal_csr(p_tal_id IN NUMBER) IS
616: SELECT kle_id