DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKC_RULE_GROUPS_B

Line 13287: okc_rule_groups_b rgpb,

13283: styb.id stream_type_id,
13284: styb.CODE stream_type_code,
13285: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13286: FROM
13287: okc_rule_groups_b rgpb,
13288: okc_rules_b rulb,
13289: okc_rules_b rulb2,
13290: okl_strm_type_b styb
13291: WHERE rgpb.dnz_chr_id = cp_chr_id

Line 13319: okc_rule_groups_b rgpb,

13315: styb.id stream_type_id,
13316: styb.CODE stream_type_code,
13317: sum(nvl((rulb2.RULE_INFORMATION3 * rulb2.RULE_INFORMATION6),0) + nvl(rulb2.RULE_INFORMATION8,0)) line_amt
13318: FROM okc_k_lines_b cleb,
13319: okc_rule_groups_b rgpb,
13320: okc_rules_b rulb,
13321: okc_rules_b rulb2,
13322: okl_strm_type_b styb
13323: WHERE rgpb.dnz_chr_id = cp_chr_id

Line 17570: okc_rule_groups_b rgp,

17566:
17567: CURSOR l_tax_schedule_csr(cp_trx_id IN NUMBER) IS
17568: SELECT rul.rule_information5
17569: FROM okc_rules_b rul,
17570: okc_rule_groups_b rgp,
17571: okl_trx_requests trx
17572: WHERE rgp.dnz_chr_id = trx.dnz_khr_id
17573: AND rul.rgp_id = rgp.id
17574: AND rgp.rgd_code = 'LAHDTX'