APPS.HZ_DSS_VALIDATE_PKG SQL Statements

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

Line: 19

SELECT count (*)
  FROM hz_dss_groups_b ;

Line: 40

SELECT object_id
FROM hz_dss_entities
WHERE entity_id = p_entity_id;

Line: 63

SELECT instance_set_id
FROM hz_dss_entities
WHERE entity_id = p_entity_id;

Line: 87

SELECT object_id
FROM fnd_object_instance_sets
WHERE instance_set_id = p_instance_set_id ;

Line: 112

SELECT 'Y'
  FROM hz_dss_groups_b
 WHERE dss_group_code = p_dss_group_code;

Line: 141

SELECT 'Y'
  FROM hz_dss_groups_vl
 WHERE dss_group_name = p_dss_group_name;

Line: 168

SELECT 'Y'
  FROM hz_dss_groups_vl
 WHERE dss_group_name = p_dss_group_name
       and dss_group_code <> p_dss_group_code ;

Line: 199

SELECT 'Y'
  FROM hz_class_categories
 WHERE class_category = p_class_category ;

Line: 228

SELECT 'Y'
  FROM hz_relationship_types
 WHERE relationship_type_id = p_relationship_type_id ;

Line: 258

select 'y'
from fnd_objects FND , hz_dss_entities  ENT
where FND.database_object_name = p_database_object_name and
      FND.object_id = ENT.object_id and
      ENT.group_assignment_level = 'ASSIGN';

Line: 289

select 'y'
from hz_dss_entities
where entity_id = p_entity_id ;

Line: 318

select 'y'
from hz_dss_entities
where entity_id = p_entity_id
      and object_id is not null ;

Line: 350

    SELECT 'Y'
    FROM hz_dss_assignments
    WHERE assignment_id = p_assignment_id ;

Line: 379

select 'Y'
from ar_lookups
where lookup_type = p_lookup_type
      and lookup_code = p_lookup_code
      and enabled_flag = 'Y' ;

Line: 409

select 'Y'
from ar_lookups
where lookup_type = p_lookup_type
      and lookup_code = p_lookup_code;

Line: 438

select 'Y'
from fnd_lookup_values
where lookup_type = p_lookup_type
      and lookup_code = p_lookup_code
      and enabled_flag = 'Y' ;

Line: 468

SELECT 'Y'
  FROM fnd_objects
 WHERE object_id = p_object_id;

Line: 499

SELECT 'Y'
  FROM fnd_object_instance_sets
 WHERE instance_set_id = p_instance_set_id;

Line: 527

SELECT 'Y'
  FROM hz_dss_entities
 WHERE entity_id = p_entity_id ;

Line: 556

select 'Y'
from fnd_form_functions where function_id = p_function_id;