APPS.CN_RULESET_PVT dependencies on CN_ATTRIBUTE_RULES

Line 32: FROM cn_attribute_rules car

28: WHERE cr.rule_id <> -1002
29: AND cr.ruleset_id = p_ruleset_id
30: AND cr.org_id=p_org_id
31: AND NOT EXISTS (SELECT 1
32: FROM cn_attribute_rules car
33: WHERE car.rule_id = cr.rule_id and
34: car.org_id=cr.org_id);
35:
36: CURSOR valid_attribute_curs IS

Line 46: FROM cn_rules cr, cn_attribute_rules attr, cn_objects col

42: attr.low_value,
43: cr.name rule_name,
44: col.user_name,
45: attr.org_id
46: FROM cn_rules cr, cn_attribute_rules attr, cn_objects col
47: WHERE cr.rule_id <> -1002
48: and col.object_id = attr.column_id
49: and col.table_id = -11803
50: AND cr.ruleset_id = p_ruleset_id

Line 679: l_object_version_number cn_attribute_rules.object_version_number%TYPE;

675: l_count NUMBER;
676:
677: l_ruleset_status VARCHAR2(100);
678: l_request_id NUMBER;
679: l_object_version_number cn_attribute_rules.object_version_number%TYPE;
680:
681: l_rules NUMBER;
682:
683: