DBA Data[Home] [Help]

APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKC_RULE_GROUPS_B

Line 290: FROM okc_rule_groups_b rgp,

286: -- Property Tax applicable cursor
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'

Line 1042: FROM okc_rule_groups_b rgp,

1038: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
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'