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 1043: okc_rules_b rul

1039: update okl_ext_billing_interface a
1040: set prop_tax_applicable_yn = (
1041: SELECT NVL(rul.rule_information1,'N')
1042: FROM okc_rule_groups_b rgp,
1043: okc_rules_b rul
1044: WHERE rgp.id = rul.rgp_id
1045: AND rgp.rgd_code = 'LAASTX'
1046: AND rul.RULE_INFORMATION_CATEGORY = 'LAPRTX'
1047: AND rul.rule_information3 is not null