APPS.OKL_TXD_ASSETS_PVT dependencies on OKL_TXD_ASSETS_V

Line 116: CURSOR header_curr_csr(p_tal_id OKL_TXD_ASSETS_V.TAL_ID%TYPE) IS

112: SELECT tal.currency_code
113: FROM OKL_TXL_ASSETS_B tal
114: WHERE tal.id = p_tal_id;
115: */
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,

Line 599: CURSOR header_curr_csr(p_txd_id OKL_TXD_ASSETS_V.ID%TYPE) IS

595: SELECT tas.currency_code
596: FROM OKL_TXD_ASSETS_B tas
597: WHERE tas.id = p_id;
598: */
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,

Line 605: okl_txd_assets_v txd

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
608: AND txd.id = p_txd_id;
609: