APPS.OKL_LA_STREAM_PVT dependencies on OKL_SGN_TRANSLATIONS

Line 1964: FROM okl_sgn_translations trns,

1960: CURSOR l_txtrans_csr (p_book fa_book_controls.book_type_code%TYPE)
1961: IS
1962: SELECT trns.value,
1963: books.book_type_code
1964: FROM okl_sgn_translations trns,
1965: fa_book_controls books
1966: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
1967: AND trns.object1_id1 = books.book_type_code
1968: AND books.book_type_code = p_book;

Line 1971: value okl_sgn_translations.value%TYPE := NULL);

1967: AND trns.object1_id1 = books.book_type_code
1968: AND books.book_type_code = p_book;
1969: TYPE tax_book_value_rec IS RECORD(
1970: tax_book okl_txd_assets_b.tax_book%TYPE := NULL ,
1971: value okl_sgn_translations.value%TYPE := NULL);
1972: TYPE tax_book_value_tbl IS TABLE OF tax_book_value_rec
1973: INDEX BY BINARY_INTEGER;
1974: lt_tax_book_value_tbl tax_book_value_tbl;
1975: BEGIN

Line 8172: FROM okl_sgn_translations sgn,

8168: CURSOR get_sub_line_csr (p_dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE)
8169: IS
8170: SELECT TO_NUMBER(sgn.value) sty_id,
8171: cle.id
8172: FROM okl_sgn_translations sgn,
8173: okl_strm_type_b sty,
8174: okl_subsidies_v sub,
8175: okl_k_lines kle,
8176: okc_statuses_b sts,

Line 8970: FROM okl_sgn_translations sgn,

8966: AND cle.id = kle.id
8967: AND kle.subsidy_id = sub.id;
8968: /*
8969: SELECT sty_inc.code strm_desc
8970: FROM okl_sgn_translations sgn,
8971: okl_strm_type_b sty_inc,
8972: okl_strm_type_b sty,
8973: okl_subsidies_v sub,
8974: okl_k_lines kle,

Line 17673: FROM okl_sgn_translations trns,

17669: CURSOR l_txtrans_csr_lease (Book Varchar2)
17670: IS
17671: SELECT trns.value,
17672: books.book_type_code
17673: FROM okl_sgn_translations trns,
17674: fa_book_controls books
17675: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
17676: AND trns.object1_id1 = books.book_type_code
17677: AND books.book_type_code = Book

Line 22044: FROM okl_sgn_translations trns,

22040: CURSOR l_txtrans_csr (Book Varchar2)
22041: IS
22042: SELECT trns.value,
22043: books.book_type_code
22044: FROM okl_sgn_translations trns,
22045: fa_book_controls books
22046: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
22047: AND trns.object1_id1 = books.book_type_code
22048: AND trns.sgn_code = 'STMP'