APPS.CN_GET_EXPRESSION SQL Statements

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

Line: 13

      SELECT operand1, operand1_ra_rae_flag,
             operand2, operand2_ra_rae_flag,
             operator
      FROM   cn_rule_attr_expression
      WHERE  rule_id = x_rule_id and org_id=x_org_id
      ORDER BY operand_expression_id;

Line: 21

      SELECT descriptive_rule_attribute
      FROM   cn_rule_attributes_desc_v
      WHERE  attribute_rule_id = x_ra_id
      and org_id=x_org_id;

Line: 105

    UPDATE cn_attribute_rules
       SET expression = substr(x_expression, 1, 1900)
     WHERE rule_id = x_rule_id and org_id=x_org_id;

Line: 115

PROCEDURE deleteExpression(x_rule_id    IN  cn_attribute_rules.rule_id%TYPE,
                           x_org_id     IN  cn_attribute_rules.org_id%TYPE) IS
BEGIN
  UPDATE cn_attribute_rules set expression = ' '  WHERE rule_id = x_rule_id and org_id=x_org_id;

Line: 120

END deleteExpression;