APPS.CN_SCA_DENORM_RULES_PVT dependencies on CN_SCA_CONDITIONS

Line 146: cn_sca_conditions c

142: dr.rule_attr_comb_value * l_attr_prime_tbl(i).prime_number
143: WHERE dr.sca_credit_rule_id IN(
144: SELECT idr.sca_credit_rule_id
145: FROM cn_sca_denorm_rules idr,
146: cn_sca_conditions c
147: WHERE idr.ancestor_rule_id = c.sca_credit_rule_id
148: AND c.sca_rule_attribute_id = rule_attr_rec.sca_rule_attribute_id
149: AND idr.transaction_source = p_transaction_source
150: AND idr.org_id = p_org_id)

Line 303: FROM cn_sca_conditions a,

299: --+
300:
301: SELECT count(1)
302: INTO l_invalid_rules
303: FROM cn_sca_conditions a,
304: cn_sca_credit_rules b
305: WHERE a.sca_credit_rule_id = b.sca_credit_rule_id
306: AND b.org_id = p_org_id
307: AND NOT EXISTS(

Line 486: cn_sca_conditions c

482: num_rule_attributes = (
483: SELECT count(distinct c.sca_rule_attribute_id)
484: FROM cn_sca_denorm_rules r,
485: cn_sca_credit_rules s,
486: cn_sca_conditions c
487: WHERE r.transaction_source = p_txn_src
488: AND s.transaction_source = p_txn_src
489: AND r.sca_credit_rule_id = c1_rec.sca_credit_rule_id
490: AND r.ancestor_rule_id = s.sca_credit_rule_id