DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_SUBSIDIES_V

Line 8174: okl_subsidies_v sub,

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,
8177: okc_line_styles_b lse,
8178: okc_k_lines_b cle

Line 8199: okl_subsidies_v sub,

8195: ,sts.ste_code
8196: --srsreeni Bug5699923 End
8197: FROM okl_k_lines kle,
8198: okc_k_lines_b cle,
8199: okl_subsidies_v sub,
8200: okc_statuses_b sts,
8201: okc_line_styles_b lse
8202: WHERE cle.dnz_chr_id = p_dnz_chr_id
8203: AND cle.lse_id = lse.id

Line 8960: okl_subsidies_v sub

8956: SELECT kle.sty_id
8957: FROM okl_k_lines kle,
8958: okc_k_lines_b cle,
8959: okc_line_styles_b lse,
8960: okl_subsidies_v sub
8961:
8962: WHERE cle.dnz_chr_id = p_dnz_chr_id
8963: AND cle.id = p_sub_cle_id
8964: AND cle.lse_id = lse.id

Line 8973: okl_subsidies_v sub,

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,
8975: okc_line_styles_b lse,
8976: okc_k_lines_b cle
8977: WHERE cle.dnz_chr_id = p_dnz_chr_id