APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKC_RULES_B

Line 237: l_p_tax_applicable okc_rules_b.rule_information3%TYPE;

233:
234: l_actual_tax_count NUMBER;
235: l_max_line_num NUMBER;
236:
237: l_p_tax_applicable okc_rules_b.rule_information3%TYPE;
238: l_vendor_id NUMBER;
239: l_vendor_site_id NUMBER;
240: l_p_tax_option okl_property_tax_setups.payable_invoice%TYPE;
241:

Line 291: okc_rules_b rul

287: ------------------------------------------------------------
288: CURSOR p_tax_app_csr( p_chr_id IN NUMBER, p_cle_id IN NUMBER ) IS
289: SELECT rul.rule_information1
290: FROM okc_rule_groups_b rgp,
291: okc_rules_b rul
292: WHERE rgp.id = rul.rgp_id
293: AND rgp.rgd_code = 'LAASTX'
294: AND rul.RULE_INFORMATION_CATEGORY = 'LAPRTX'
295: AND rul.rule_information3 is not null

Line 1115: okc_rules_b rul

1111: update okl_ext_billing_interface a
1112: set prop_tax_applicable_yn = (
1113: SELECT NVL(rul.rule_information1,'N')
1114: FROM okc_rule_groups_b rgp,
1115: okc_rules_b rul
1116: WHERE rgp.id = rul.rgp_id
1117: AND rgp.rgd_code = 'LAASTX'
1118: AND rul.RULE_INFORMATION_CATEGORY = 'LAPRTX'
1119: AND rul.rule_information3 is not null