APPS.CN_SCA_DENORM_RULES_PVT dependencies on CN_SCA_RULE_ATTRIBUTES

Line 43: cn_sca_rule_attributes ra

39: CURSOR rule_attr_cur IS
40: SELECT mv.sca_rule_attribute_id,
41: ra.src_column_name
42: FROM cn_sca_rule_cond_vals_mv mv,
43: cn_sca_rule_attributes ra
44: WHERE mv.sca_rule_attribute_id = ra.sca_rule_attribute_id
45: AND mv.transaction_source = p_transaction_source
46: AND EXISTS(
47: SELECT 'X'

Line 309: FROM cn_sca_rule_attributes c

305: WHERE a.sca_credit_rule_id = b.sca_credit_rule_id
306: AND b.org_id = p_org_id
307: AND NOT EXISTS(
308: SELECT 'X'
309: FROM cn_sca_rule_attributes c
310: WHERE a.sca_rule_attribute_id = c.sca_rule_attribute_id)
311: AND b.transaction_source = p_txn_src;
312:
313: IF (l_invalid_rules > 0) THEN