APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_LINE_STYLES_B

Line 1469: okc_line_styles_b lse,

1465: SELECT cle.id, cle.name, cle.item_description
1466: FROM okc_k_lines_v cle,
1467: okc_rule_groups_b rg1,
1468: okc_rules_b rl1,
1469: okc_line_styles_b lse,
1470: okc_rule_groups_b rg2,
1471: okc_rules_b rl2
1472: WHERE cle.chr_ID = p_contract_id
1473: AND cle.lse_id = lse.id

Line 1501: okc_line_styles_b lse

1497: SELECT cle.id, cle.name, cle.item_description
1498: FROM okc_k_lines_v cle,
1499: okc_rule_groups_b rg1,
1500: okc_rules_b rl1,
1501: okc_line_styles_b lse
1502: WHERE cle.dnz_chr_id = p_contract_id
1503: AND cle.lse_id = lse.id
1504: AND lse.lty_code = 'FREE_FORM1'
1505: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 2363: okc_line_styles_b lse,

2359: SELECT cle.id, cle.name, cle.item_description
2360: FROM okc_k_lines_v cle,
2361: okc_rule_groups_b rg1,
2362: okc_rules_b rl1,
2363: okc_line_styles_b lse,
2364: okc_rule_groups_b rg2,
2365: okc_rules_b rl2
2366: WHERE cle.chr_ID = p_contract_id
2367: AND cle.lse_id = lse.id

Line 2396: okc_line_styles_b lse

2392: SELECT cle.id, cle.name, cle.item_description
2393: FROM okc_k_lines_v cle,
2394: okc_rule_groups_b rg1,
2395: okc_rules_b rl1,
2396: okc_line_styles_b lse
2397: WHERE cle.dnz_chr_ID = p_contract_id
2398: AND cle.lse_id = lse.id
2399: AND lse.lty_code = 'FREE_FORM1'
2400: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 5756: okc_line_styles_b sty

5752: nvl(kle.amount,0) amount,
5753: nvl(kle.capital_amount,0) capital_amount
5754: FROM okc_k_lines_b cleb,
5755: okl_k_lines kle,
5756: okc_line_styles_b sty
5757: WHERE cle_id = p_cleId
5758: AND cleb.id = kle.id
5759: AND cleb.lse_id = sty.id
5760: AND sty.lty_code = 'LINK_FEE_ASSET';

Line 5781: okc_line_styles_b sty,

5777: CURSOR l_asset_csr IS
5778: SELECT cle.id,
5779: name
5780: FROM okc_k_lines_v cle,
5781: okc_line_styles_b sty,
5782: okc_statuses_b sts
5783: WHERE cle.lse_id = sty.id
5784: AND cle.dnz_chr_id = p_chr_id
5785: AND lty_code = 'FREE_FORM1'

Line 5800: okc_line_styles_b sty

5796: okc_k_lines_b cleb,
5797: okl_k_lines kle,
5798: okc_k_items item,
5799: okc_k_lines_tl clet_asset,
5800: okc_line_styles_b sty
5801: WHERE fee_line.id = kle.id
5802: AND kle.FEE_PURPOSE_CODE='SALESTAX'
5803: AND cleb.lse_id = sty.id
5804: AND sty.lty_code = 'LINK_FEE_ASSET'

Line 5841: okc_line_styles_b sty,

5837: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5838: SELECT COUNT(cleb.id)
5839: FROM okc_k_lines_b cleb,
5840: okl_k_lines kle,
5841: okc_line_styles_b sty,
5842: okc_statuses_b sts
5843: WHERE cleb.lse_id = sty.id
5844: AND sty.lty_code = 'FEE'
5845: AND cleb.sts_code = sts.code