APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_LINE_STYLES_B

Line 1655: okc_line_styles_b lse,

1651: SELECT cle.id, cle.name, cle.item_description
1652: FROM okc_k_lines_v cle,
1653: okc_rule_groups_b rg1,
1654: okc_rules_b rl1,
1655: okc_line_styles_b lse,
1656: okc_rule_groups_b rg2,
1657: okc_rules_b rl2
1658: WHERE cle.chr_ID = p_contract_id
1659: AND cle.lse_id = lse.id

Line 1687: okc_line_styles_b lse

1683: SELECT cle.id, cle.name, cle.item_description
1684: FROM okc_k_lines_v cle,
1685: okc_rule_groups_b rg1,
1686: okc_rules_b rl1,
1687: okc_line_styles_b lse
1688: WHERE cle.dnz_chr_id = p_contract_id
1689: AND cle.lse_id = lse.id
1690: AND lse.lty_code = 'FREE_FORM1'
1691: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 2567: okc_line_styles_b lse,

2563: SELECT cle.id, cle.name, cle.item_description
2564: FROM okc_k_lines_v cle,
2565: okc_rule_groups_b rg1,
2566: okc_rules_b rl1,
2567: okc_line_styles_b lse,
2568: okc_rule_groups_b rg2,
2569: okc_rules_b rl2
2570: WHERE cle.chr_ID = p_contract_id
2571: AND cle.lse_id = lse.id

Line 2600: okc_line_styles_b lse

2596: SELECT cle.id, cle.name, cle.item_description
2597: FROM okc_k_lines_v cle,
2598: okc_rule_groups_b rg1,
2599: okc_rules_b rl1,
2600: okc_line_styles_b lse
2601: WHERE cle.dnz_chr_ID = p_contract_id
2602: AND cle.lse_id = lse.id
2603: AND lse.lty_code = 'FREE_FORM1'
2604: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 6152: okc_line_styles_b sty

6148: nvl(kle.amount,0) amount,
6149: nvl(kle.capital_amount,0) capital_amount
6150: FROM okc_k_lines_b cleb,
6151: okl_k_lines kle,
6152: okc_line_styles_b sty
6153: WHERE cle_id = p_cleId
6154: AND cleb.id = kle.id
6155: AND cleb.lse_id = sty.id
6156: AND sty.lty_code = 'LINK_FEE_ASSET';

Line 6177: okc_line_styles_b sty,

6173: CURSOR l_asset_csr IS
6174: SELECT cle.id,
6175: name
6176: FROM okc_k_lines_v cle,
6177: okc_line_styles_b sty,
6178: okc_statuses_b sts
6179: WHERE cle.lse_id = sty.id
6180: AND cle.dnz_chr_id = p_chr_id
6181: AND lty_code = 'FREE_FORM1'

Line 6196: okc_line_styles_b sty

6192: okc_k_lines_b cleb,
6193: okl_k_lines kle,
6194: okc_k_items item,
6195: okc_k_lines_tl clet_asset,
6196: okc_line_styles_b sty
6197: WHERE fee_line.id = kle.id
6198: AND kle.FEE_PURPOSE_CODE='SALESTAX'
6199: AND cleb.lse_id = sty.id
6200: AND sty.lty_code = 'LINK_FEE_ASSET'

Line 6237: okc_line_styles_b sty,

6233: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6234: SELECT COUNT(cleb.id)
6235: FROM okc_k_lines_b cleb,
6236: okl_k_lines kle,
6237: okc_line_styles_b sty,
6238: okc_statuses_b sts
6239: WHERE cleb.lse_id = sty.id
6240: AND sty.lty_code = 'FEE'
6241: AND cleb.sts_code = sts.code