DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_RULE_GROUPS_B

Line 13237: okc_rule_groups_b rgpb,

13233: styb.id stream_type_id,
13234: styb.CODE stream_type_code,
13235: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13236: FROM
13237: okc_rule_groups_b rgpb,
13238: okc_rules_b rulb,
13239: okc_rules_b rulb2,
13240: okl_strm_type_b styb
13241: WHERE rgpb.dnz_chr_id = cp_chr_id

Line 13259: okc_rule_groups_b rgpb,

13255: styb.id stream_type_id,
13256: styb.CODE stream_type_code,
13257: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13258: FROM okc_k_lines_b cleb,
13259: okc_rule_groups_b rgpb,
13260: okc_rules_b rulb,
13261: okc_rules_b rulb2,
13262: okl_strm_type_b styb
13263: WHERE rgpb.dnz_chr_id = cp_chr_id

Line 17498: okc_rule_groups_b rgp,

17494:
17495: CURSOR l_tax_schedule_csr(cp_trx_id IN NUMBER) IS
17496: SELECT rul.rule_information5
17497: FROM okc_rules_b rul,
17498: okc_rule_groups_b rgp,
17499: okl_trx_requests trx
17500: WHERE rgp.dnz_chr_id = trx.dnz_khr_id
17501: AND rul.rgp_id = rgp.id
17502: AND rgp.rgd_code = 'LAHDTX'