DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_STRM_TYPE_B

Line 6517: okl_strm_type_b sty,

6513: styt.name stream_type
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'

Line 6538: okl_strm_type_b sty,

6534:
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'

Line 6556: okl_strm_type_b sty,

6552: rule.id rule_id,
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'