APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_STRM_TYPE_TL

Line 1733: from OKL_STRM_TYPE_TL

1729:
1730: --Bug# 12807203
1731: CURSOR stream_csr (stream_type_id IN NUMBER) IS
1732: select name
1733: from OKL_STRM_TYPE_TL
1734: where id = stream_type_id
1735: AND language = USERENV('LANG');
1736:
1737: l_strm_type_name OKL_STRM_TYPE_TL.name%TYPE;

Line 1737: l_strm_type_name OKL_STRM_TYPE_TL.name%TYPE;

1733: from OKL_STRM_TYPE_TL
1734: where id = stream_type_id
1735: AND language = USERENV('LANG');
1736:
1737: l_strm_type_name OKL_STRM_TYPE_TL.name%TYPE;
1738:
1739: -- Cursor to get fee covered asset line
1740: -- Bug# 6512668: Exclude covered asset lines in Abandoned status
1741: CURSOR l_cov_asset_line_csr(p_chr_id IN NUMBER,

Line 2549: from OKL_STRM_TYPE_TL

2545:
2546: -- cursor to get item id
2547: CURSOR stream_csr (stream_type_id IN NUMBER) IS
2548: select name
2549: from OKL_STRM_TYPE_TL
2550: where id = stream_type_id
2551: AND language = USERENV('LANG');
2552:
2553: -- Get contract dates

Line 7065: okl_strm_type_tl styt

7061: FROM okc_rules_b sll,
7062: okc_rules_b slh,
7063: okc_rule_groups_b rgp,
7064: okl_strm_type_b sty,
7065: okl_strm_type_tl styt
7066: WHERE rgp.dnz_chr_id = p_chr_id
7067: AND rgp.cle_id = p_fee_line_id
7068: AND rgp.rgd_code = 'LALEVL'
7069: AND rgp.id = slh.rgp_id

Line 7086: okl_strm_type_tl styt

7082: SELECT slh.id
7083: FROM okc_rules_b slh,
7084: okc_rule_groups_b rgp,
7085: okl_strm_type_b sty,
7086: okl_strm_type_tl styt
7087: WHERE rgp.dnz_chr_id = p_chr_id
7088: AND rgp.cle_id = p_fee_line_id
7089: AND rgp.rgd_code = 'LALEVL'
7090: AND rgp.id = slh.rgp_id

Line 7104: okl_strm_type_tl styt

7100: rgp.id rgp_id
7101: FROM okc_rules_b rule,
7102: okc_rule_groups_b rgp,
7103: okl_strm_type_b sty,
7104: okl_strm_type_tl styt
7105: WHERE NVL(rgp.cle_id, -1) = p_kle_id
7106: AND rgp.dnz_chr_id = p_khr_id
7107: AND rgp.rgd_code = 'LALEVL'
7108: AND rgp.id = rule.rgp_id