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 1114: FROM okc_rule_groups_b rgp,

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