APPS.OKL_LA_STREAM_PVT dependencies on OKL_SUBSIDIES_B

Line 5545: FROM okl_subsidies_b subb,

5541: IS
5542: SELECT 1
5543: FROM dual
5544: WHERE EXISTS (SELECT '1'
5545: FROM okl_subsidies_b subb,
5546: okc_k_lines_b cle_fin,
5547: okc_line_styles_b lse_fin,
5548: okc_k_lines_b cle,
5549: okl_k_headers khr,

Line 8885: lv_acc_mtd_code okl_subsidies_b.accounting_method_code%TYPE := NULL;

8881: AS
8882: l_api_name CONSTANT VARCHAR2(30) := 'EXTRACT_SUBSIDIZED_LINES';
8883: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type := px_csm_one_off_fee_tbl;
8884: i BINARY_INTEGER := 0;
8885: lv_acc_mtd_code okl_subsidies_b.accounting_method_code%TYPE := NULL;
8886: lv_strm_desc VARCHAR2(200);
8887: ln_sub_id okc_k_lines_b.id%TYPE := NULL;
8888: ln_dummy NUMBER := 0;
8889: ln_cap_wos okl_k_lines.capital_amount%TYPE := 0;

Line 8914: FROM okl_subsidies_b subb,

8910: CURSOR get_acc_mth_code (p_line_id OKL_K_LINES.ID%TYPE)
8911: IS
8912: SELECT subb.accounting_method_code,
8913: cle.id
8914: FROM okl_subsidies_b subb,
8915: okc_k_lines_b cle_fin,
8916: okc_line_styles_b lse_fin,
8917: okc_k_lines_b cle,
8918: okl_k_lines kle,

Line 8934: FROM okl_subsidies_b subb,

8930: IS
8931: SELECT 1
8932: FROM dual
8933: WHERE EXISTS (SELECT '1'
8934: FROM okl_subsidies_b subb,
8935: okc_k_lines_b cle_fin,
8936: okc_line_styles_b lse_fin,
8937: okc_k_lines_b cle,
8938: okl_k_lines kle,

Line 17652: FROM okl_subsidies_b subb,

17648: -- get discount amount on the line
17649: CURSOR get_dis_amt_csr_lease(p_chr_id NUMBER, p_cle_id NUMBER)
17650: IS
17651: SELECT kle_sub.amount, kle_sub.SUBSIDY_OVERRIDE_AMOUNT
17652: FROM okl_subsidies_b subb,
17653: okc_k_lines_b cle_fin,
17654: okc_line_styles_b lse_fin,
17655: okc_k_lines_b cle_sub,
17656: okl_k_lines kle_sub,