APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_STRM_TYPE_TL

Line 2346: from OKL_STRM_TYPE_TL

2342:
2343: -- cursor to get item id
2344: CURSOR stream_csr (stream_type_id IN NUMBER) IS
2345: select name
2346: from OKL_STRM_TYPE_TL
2347: where id = stream_type_id;
2348:
2349: -- Get contract dates
2350: CURSOR contract_dates_csr IS

Line 6518: okl_strm_type_tl styt

6514: FROM okc_rules_b sll,
6515: okc_rules_b slh,
6516: okc_rule_groups_b rgp,
6517: okl_strm_type_b sty,
6518: okl_strm_type_tl styt
6519: WHERE rgp.dnz_chr_id = p_chr_id
6520: AND rgp.cle_id = p_fee_line_id
6521: AND rgp.rgd_code = 'LALEVL'
6522: AND rgp.id = slh.rgp_id

Line 6539: okl_strm_type_tl styt

6535: SELECT slh.id
6536: FROM okc_rules_b slh,
6537: okc_rule_groups_b rgp,
6538: okl_strm_type_b sty,
6539: okl_strm_type_tl styt
6540: WHERE rgp.dnz_chr_id = p_chr_id
6541: AND rgp.cle_id = p_fee_line_id
6542: AND rgp.rgd_code = 'LALEVL'
6543: AND rgp.id = slh.rgp_id

Line 6557: okl_strm_type_tl styt

6553: rgp.id rgp_id
6554: FROM okc_rules_b rule,
6555: okc_rule_groups_b rgp,
6556: okl_strm_type_b sty,
6557: okl_strm_type_tl styt
6558: WHERE NVL(rgp.cle_id, -1) = p_kle_id
6559: AND rgp.dnz_chr_id = p_khr_id
6560: AND rgp.rgd_code = 'LALEVL'
6561: AND rgp.id = rule.rgp_id