APPS.OKL_LA_STREAM_PVT dependencies on OKL_SGN_TRANSLATIONS

Line 1943: FROM okl_sgn_translations trns,

1939: CURSOR l_txtrans_csr (p_book fa_book_controls.book_type_code%TYPE)
1940: IS
1941: SELECT trns.value,
1942: books.book_type_code
1943: FROM okl_sgn_translations trns,
1944: fa_book_controls books
1945: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
1946: AND trns.object1_id1 = books.book_type_code
1947: AND books.book_type_code = p_book;

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

1946: AND trns.object1_id1 = books.book_type_code
1947: AND books.book_type_code = p_book;
1948: TYPE tax_book_value_rec IS RECORD(
1949: tax_book okl_txd_assets_b.tax_book%TYPE := NULL ,
1950: value okl_sgn_translations.value%TYPE := NULL);
1951: TYPE tax_book_value_tbl IS TABLE OF tax_book_value_rec
1952: INDEX BY BINARY_INTEGER;
1953: lt_tax_book_value_tbl tax_book_value_tbl;
1954: BEGIN

Line 9692: FROM okl_sgn_translations sgn,

9688: CURSOR get_sub_line_csr (p_dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE)
9689: IS
9690: SELECT TO_NUMBER(sgn.value) sty_id,
9691: cle.id
9692: FROM okl_sgn_translations sgn,
9693: okl_strm_type_b sty,
9694: okl_subsidies_v sub,
9695: okl_k_lines kle,
9696: okc_statuses_b sts,

Line 10515: FROM okl_sgn_translations sgn,

10511: AND cle.id = kle.id
10512: AND kle.subsidy_id = sub.id;
10513: /*
10514: SELECT sty_inc.code strm_desc
10515: FROM okl_sgn_translations sgn,
10516: okl_strm_type_b sty_inc,
10517: okl_strm_type_b sty,
10518: okl_subsidies_v sub,
10519: okl_k_lines kle,

Line 20311: FROM okl_sgn_translations trns,

20307: CURSOR l_txtrans_csr_lease (Book Varchar2)
20308: IS
20309: SELECT trns.value,
20310: books.book_type_code
20311: FROM okl_sgn_translations trns,
20312: fa_book_controls books
20313: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
20314: AND trns.object1_id1 = books.book_type_code
20315: AND books.book_type_code = Book

Line 24887: FROM okl_sgn_translations trns,

24883: CURSOR l_txtrans_csr (Book Varchar2)
24884: IS
24885: SELECT trns.value,
24886: books.book_type_code
24887: FROM okl_sgn_translations trns,
24888: fa_book_controls books
24889: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
24890: AND trns.object1_id1 = books.book_type_code
24891: AND trns.sgn_code = 'STMP'