APPS.CN_SCA_CRRULEATTR_PVT dependencies on CN_SCA_CONDITIONS

Line 589: FROM CN_SCA_CONDITIONS

585: IF (l_value_set_id IS NULL AND l_credit_rule_attr_rec.user_name IS NULL
586: AND l_credit_rule_attr_rec.source_column IS NULL
587: AND l_credit_rule_attr_rec.enable_flag ='N') THEN
588: SELECT count(1) into l_count2
589: FROM CN_SCA_CONDITIONS
590: WHERE SCA_RULE_ATTRIBUTE_ID= l_credit_rule_attr_rec.sca_rule_attribute_id
591: AND ORG_ID = p_org_id; -- MOAC Change
592:
593: IF l_count2 = 0 THEN

Line 638: SELECT count(1) into l_count2 FROM CN_SCA_CONDITIONS WHERE

634: END IF ;
635: --END IF;
636:
637: l_count2 :=0;
638: SELECT count(1) into l_count2 FROM CN_SCA_CONDITIONS WHERE
639: SCA_RULE_ATTRIBUTE_ID= l_credit_rule_attr_rec.sca_rule_attribute_id
640: and org_id = p_org_id; -- MOAC Change
641: IF l_count2 = 0 THEN
642: