DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_SUBSIDIES_V

Line 9694: okl_subsidies_v sub,

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,
9697: okc_line_styles_b lse,
9698: okc_k_lines_b cle

Line 9719: okl_subsidies_v sub,

9715: ,sts.ste_code
9716: --srsreeni Bug5699923 End
9717: FROM okl_k_lines kle,
9718: okc_k_lines_b cle,
9719: okl_subsidies_v sub,
9720: okc_statuses_b sts,
9721: okc_line_styles_b lse
9722: WHERE cle.dnz_chr_id = p_dnz_chr_id
9723: AND cle.lse_id = lse.id

Line 10505: okl_subsidies_v sub

10501: SELECT kle.sty_id
10502: FROM okl_k_lines kle,
10503: okc_k_lines_b cle,
10504: okc_line_styles_b lse,
10505: okl_subsidies_v sub
10506:
10507: WHERE cle.dnz_chr_id = p_dnz_chr_id
10508: AND cle.id = p_sub_cle_id
10509: AND cle.lse_id = lse.id

Line 10518: okl_subsidies_v sub,

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,
10520: okc_line_styles_b lse,
10521: okc_k_lines_b cle
10522: WHERE cle.dnz_chr_id = p_dnz_chr_id