APPS.OKL_TXD_ASSETS_PVT dependencies on OKL_TXL_ASSETS_B

Line 103: okl_txl_assets_b tal,

99: CURSOR get_chr_id(p_tal_id OKL_TXD_ASSETS_B.TAL_ID%TYPE)
100: IS
101: SELECT to_char(cle.dnz_chr_id)
102: FROM okc_k_lines_b cle,
103: okl_txl_assets_b tal,
104: okl_txd_assets_b txd
105: WHERE tal.kle_id = cle.id
106: AND tal.id = txd.tal_id
107: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')

Line 111: CURSOR c_get_currency_code(p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) IS

107: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')
108: AND txd.tal_id = p_tal_id;
109:
110: /*
111: CURSOR c_get_currency_code(p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) IS
112: SELECT tal.currency_code
113: FROM OKL_TXL_ASSETS_B tal
114: WHERE tal.id = p_tal_id;
115: */

Line 113: FROM OKL_TXL_ASSETS_B tal

109:
110: /*
111: CURSOR c_get_currency_code(p_tal_id OKL_TXL_ASSETS_B.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,

Line 133: okl_txl_assets_b tal,

129: CURSOR get_chr_and_cle_id(p_tal_id OKL_TXD_ASSETS_B.TAL_ID%TYPE)
130: IS
131: SELECT to_char(cle.dnz_chr_id) chr_id, cle.cle_id cle_id
132: FROM okc_k_lines_b cle,
133: okl_txl_assets_b tal,
134: okl_txd_assets_b txd
135: WHERE tal.kle_id = cle.id
136: AND tal.id = txd.tal_id
137: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')

Line 155: FROM okl_txl_assets_b tal

151:
152: --Bug# 4959361
153: CURSOR l_tal_csr(p_tal_id IN NUMBER) IS
154: SELECT kle_id
155: FROM okl_txl_assets_b tal
156: WHERE tal.id = p_tal_id;
157:
158: l_tal_rec l_tal_csr%ROWTYPE;
159: --Bug# 4959361

Line 587: okl_txl_assets_b tal,

583: CURSOR get_chr_id(p_tal_id OKL_TXD_ASSETS_B.TAL_ID%TYPE)
584: IS
585: SELECT to_char(cle.dnz_chr_id)
586: FROM okc_k_lines_b cle,
587: okl_txl_assets_b tal,
588: okl_txd_assets_b txd
589: WHERE tal.kle_id = cle.id
590: AND tal.id = txd.tal_id
591: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')

Line 617: FROM okl_txl_assets_b tal

613:
614: --Bug# 4959361
615: CURSOR l_tal_csr(p_tal_id IN NUMBER) IS
616: SELECT kle_id
617: FROM okl_txl_assets_b tal
618: WHERE tal.id = p_tal_id;
619:
620: l_tal_rec l_tal_csr%ROWTYPE;
621: --Bug# 4959361

Line 900: okl_txl_assets_b tal,

896: CURSOR get_chr_id(p_txd_id OKL_TXD_ASSETS_B.ID%TYPE)
897: IS
898: SELECT to_char(cle.dnz_chr_id)
899: FROM okc_k_lines_b cle,
900: okl_txl_assets_b tal,
901: okl_txd_assets_b txd
902: WHERE tal.kle_id = cle.id
903: AND tal.id = txd.tal_id
904: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')

Line 915: okl_txl_assets_b tal,

911: CURSOR get_chr_and_cle_id(p_id OKL_TXD_ASSETS_B.ID%TYPE)
912: IS
913: SELECT to_char(cle.dnz_chr_id) chr_id, cle.cle_id cle_id
914: FROM okc_k_lines_b cle,
915: okl_txl_assets_b tal,
916: okl_txd_assets_b txd
917: WHERE tal.kle_id = cle.id
918: AND tal.id = txd.tal_id
919: AND tal.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI')

Line 933: FROM okl_txl_assets_b tal,

929:
930: --Bug# 4959361
931: CURSOR l_tal_csr(p_txd_id IN NUMBER) IS
932: SELECT tal.kle_id
933: FROM okl_txl_assets_b tal,
934: okl_txd_assets_b txd
935: WHERE tal.id = txd.tal_id
936: AND txd.id = p_txd_id;
937: