APPS.EGO_RULES_UTIL_PVT SQL Statements

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

Line: 8

	SELECT e1.USER_DATA_LEVEL_NAME
	FROM ego_data_level_vl e1, EGO_INCLUDED_BUSINESSENTITIES e2
	WHERE e1.attr_group_type = 'EGO_ITEMMGMT_GROUP'
	-- AND  e1.enable_defaulting < > 'N'
	AND e1.DATA_LEVEL_NAME= e2.BUSINESS_ENTITY
	AND e2.RULESET_ID=X_STR_ID
	);

Line: 36

		SELECT  catalog_group INTO l_result  FROM ego_catalog_groups_v WHERE catalog_group_id = X_ICC_ID;

Line: 43

  (SELECT unique
    attr_group_name
  FROM
    ego_rule_attribute_usages
  WHERE
    rule_id = X_STR_RULEID);

Line: 73

  (SELECT unique
    attribute
  FROM
    ego_rule_attribute_usages
  WHERE
    rule_id = X_STR_RULEID);

Line: 102

  (SELECT unique
    attr_group_name Assignedtoattrgrp
  FROM
    ego_rule_attribute_usages
  WHERE
    rule_id IN (SELECT RULE_ID FROM EGO_USER_RULES_B WHERE RULESET_ID = X_STR_RULESETID));

Line: 133

  (SELECT unique
    ATTRIBUTE
  FROM
    ego_rule_attribute_usages
  WHERE
    rule_id IN (SELECT RULE_ID FROM EGO_USER_RULES_B WHERE RULESET_ID = X_STR_RULESETID));

Line: 165

	SELECT
		e1.USER_DATA_LEVEL_NAME as Assignedtobusentity
	FROM
		ego_data_level_vl e1,
		EGO_RULE_ASSIGNMENTS e2
	WHERE
		e1.attr_group_type = 'EGO_ITEMMGMT_GROUP'
	--AND   e1.enable_defaulting < > 'N'
	AND
		e1.DATA_LEVEL_NAME= e2.BUSINESS_ENTITY
	AND
		e2.RULESET_ID = X_STR_RULESETID
	);

Line: 205

		SELECT
			e1.USER_DATA_LEVEL_NAME as usingbusentity
		FROM
			ego_data_level_vl e1,
			EGO_INCLUDED_BUSINESSENTITIES e2
		WHERE
			e1.attr_group_type = 'EGO_ITEMMGMT_GROUP'
		-- AND     e1.enable_defaulting < > 'N'
		AND
			e1.DATA_LEVEL_NAME = e2.BUSINESS_ENTITY
		AND
			e2.RULESET_ID = X_STR_RULESETID
	);