APPS.CN_RULES_DISP_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

  G_LAST_UPDATE_DATE          DATE    := sysdate;

Line: 7

  G_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;

Line: 10

  G_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;

Line: 54

  SELECT  0 rule_level, cnr.name rule_name, cnrc.name revenue_class,
            cnr.rule_id rule_id
         FROM cn_rules cnr, cn_revenue_classes cnrc
         WHERE cnr.rule_id = Nvl(l_parent_rule_id,-1002)
         AND   cnr.ruleset_id = Nvl(l_ruleset_id,-1002)
         AND  cnr.revenue_class_id = cnrc.revenue_class_id (+)
         AND cnr.rule_id  IN (SELECT rule_id FROM cn_rules_hierarchy);

Line: 63

         SELECT a.rule_level rule_level,cnr.name rule_name,
           cnrc.name revenue_class, a.rule_id rule_id
         FROM
         (
           SELECT level rule_level, rule_id, parent_rule_id, sequence_number
           FROM cn_rules_hierarchy
           WHERE ruleset_id=Nvl(l_ruleset_id,-1002)
           CONNECT BY PRIOR  rule_id =  parent_rule_id
           START WITH parent_rule_id = Nvl(l_parent_rule_id, -1002)
         )  a , cn_rules cnr, cn_revenue_classes cnrc
         WHERE  a.rule_id = cnr.rule_id
         AND cnr.ruleset_id = Nvl(l_ruleset_id,-1002)
         AND      cnr.revenue_class_id = cnrc.revenue_class_id (+);

Line: 79

       SELECT cnobj.user_name object_name,
         cnh.name hierarchy_name, cnattr.column_value column_value,
         cnattr.not_flag not_flag, cnattr.high_value high_value,
         cnattr.low_value low_value , cnattr.dimension_hierarchy_id dimension_hierarchy_id
       FROM cn_attribute_rules cnattr, cn_objects cnobj,
         cn_head_hierarchies cnh
       WHERE cnattr.rule_id = l_rule_id
       AND   cnattr.ruleset_id = l_ruleset_id
       AND cnattr.column_id = cnobj.object_id (+)
       AND cnattr.dimension_hierarchy_id = cnh.head_hierarchy_id(+);

Line: 120

   x_loading_status := 'CN_INSERTED';

Line: 164

        SELECT COUNT(1)
        INTO l_user_expression
        FROM CN_RULE_ATTR_EXPRESSION
        WHERE RULE_ID = rules.rule_id ;

Line: 173

          SELECT DISTINCT expression
          INTO x_rules_display_tbl(x_rules_count).rule_expression
          FROM CN_ATTRIBUTE_RULES
          WHERE RULE_ID = rules.rule_id ;

Line: 191

		SELECT name INTO node_value
		FROM cn_hierarchy_nodes
		WHERE value_id=l_column_value;

Line: 242

        SELECT COUNT(1)
        INTO l_user_expression
        FROM CN_RULE_ATTR_EXPRESSION
        WHERE RULE_ID = rules.rule_id ;

Line: 251

          SELECT DISTINCT expression
          INTO x_rules_display_tbl(x_rules_count).rule_expression
          FROM CN_ATTRIBUTE_RULES
          WHERE RULE_ID = rules.rule_id ;

Line: 269

		SELECT name INTO node_value
		FROM cn_hierarchy_nodes
		WHERE value_id=l_column_value;