APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_STRM_ELEMENTS

Line 8225: okl_strm_elements selm,

8221: NULL ship_to_siteuseid,
8222: NULL inventory_item_id
8223: FROM okl_strm_type_b typ,
8224: okl_streams strm,
8225: okl_strm_elements selm,
8226: okc_k_lines_b lines,
8227: okc_line_styles_b lse
8228: WHERE strm.sty_id = typ.id
8229: AND strm.id = selm.stm_id

Line 8261: okl_strm_elements selm,

8257: cnsld.customer_trx_line_id,
8258: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8259: FROM okl_strm_type_b typ,
8260: okl_streams strm,
8261: okl_strm_elements selm,
8262: okc_k_lines_b lines,
8263: okc_line_styles_b lse,
8264: okl_bpd_tld_ar_lines_v cnsld
8265: WHERE strm.sty_id = typ.id

Line 11016: FROM okl_strm_elements

11012:
11013: -- get the total stream amount
11014: CURSOR l_strmelements_csr(cp_stm_id IN NUMBER) IS
11015: SELECT sum(amount)
11016: FROM okl_strm_elements
11017: WHERE stm_id = cp_stm_id;
11018:
11019: -- Chaeck if tax basis override formula exists
11020: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS