DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 8243: FROM okl_bpd_tld_ar_lines_v cnsld

8239: AND NOT EXISTS -- tax lines don't exist in AR ( This condition is added to pick up stream elements billed under
8240: -- old solution : date_billed may not be null but billing may not have been run completely, so tax
8241: -- may not have been calculated in AR
8242: (SELECT NULL
8243: FROM okl_bpd_tld_ar_lines_v cnsld
8244: WHERE cnsld.sel_id = selm.id)
8245: ORDER BY strm.kle_id, strm.sty_id;
8246:
8247: -- get Billed stream elements

Line 8264: okl_bpd_tld_ar_lines_v cnsld

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
8266: AND strm.id = selm.stm_id
8267: AND typ.billable_yn = 'Y'
8268: AND strm.say_code ='CURR'