APPS.HXC_SEEDDATA_PKG SQL Statements

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

Line: 9

            := 'select Layout_Name Value, Layout_ID ID from hxc_layouts ';

Line: 12

            := 'select alias_definition_name VALUE,alias_definition_id ID from hxc_alias_definitions
                 ';

Line: 16

            :=  'select ALIAS_TYPE||''-''||REFERENCE_OBJECT Value,ALIAS_TYPE_ID ID from hxc_alias_types
                 ';

Line: 21

     	  := 'SELECT NAME VALUE, time_source_id id
	 		  FROM hxc_time_sources
	 	  	  ';

Line: 26

          := 'SELECT NAME VALUE, time_recipient_id id
                FROM hxc_time_recipients
                ';

Line: 31

            := 'SELECT NAME VALUE, mapping_component_id ID
	             FROM hxc_mapping_components
	            ';

Line: 36

           := 'SELECT NAME VALUE, mapping_id ID
                 FROM hxc_mappings
                ';

Line: 42

          := 'SELECT NAME VALUE, retrieval_process_id id
                FROM hxc_retrieval_processes
               ';

Line: 48

           := 'SELECT NAME VALUE, retrieval_rule_id id
                 FROM hxc_retrieval_rules
                ';

Line: 54

          := 'SELECT NAME VALUE, deposit_process_id id
                FROM hxc_deposit_processes
               ';

Line: 60

         := 'SELECT has.NAME VALUE, has.approval_style_id id
               FROM hxc_approval_styles has
               ';

Line: 65

          := '   SELECT dar.NAME Value, dru.data_app_rule_usage_id id
                 FROM hxc_time_entry_rules dar, hxc_data_app_rule_usages dru
                 WHERE dru.time_entry_rule_id = dar.time_entry_rule_id
	               ';

Line: 71

          := 'SELECT NAME VALUE, recurring_period_id id
                FROM hxc_recurring_periods
               ';

Line: 76

          := 'SELECT NAME VALUE, approval_period_set_id id
                FROM hxc_approval_period_sets
                ';

Line: 82

            := '   SELECT heg.NAME Value, heg.entity_group_id ID
                     FROM hxc_entity_groups heg
                    WHERE heg.entity_type = ''TIME_RECIPIENTS''
	                   ';

Line: 88

            := '   SELECT heg.NAME Value, heg.entity_group_id ID
                     FROM hxc_entity_groups heg
                    WHERE heg.entity_type = ''TIME_ENTRY_RULES''
	                   ';

Line: 95

            := '   SELECT heg.NAME Value, heg.entity_group_id ID
                     FROM hxc_entity_groups heg
                    WHERE heg.entity_type = ''RETRIEVAL_RULES''
	                   ';

Line: 102

         := 'SELECT time_category_name VALUE, time_category_id id
               FROM hxc_time_categories
              ';

Line: 108

            :=   'SELECT LOCKER_TYPE||''-''||PROCESS_TYPE VALUE, locker_type_id ID
                    FROM hxc_locker_types
                   ';

Line: 114

            := 'SELECT name Value,pref_hierarchy_id ID FROM hxc_pref_hierarchies
                ';

Line: 119

           := 'SELECT NAME VALUE, time_entry_rule_id id
  				 FROM hxc_time_entry_rules
                ';

Line: 196

	   l_query := 'SELECT Value from ('||l_query||') where ID = :p_object_id';

Line: 214

   select legislation_code from hxc_alias_definitions
    where alias_definition_id = p_object_id;

Line: 218

   select legislation_code from hxc_pref_hierarchies
    where pref_hierarchy_id = p_object_id;

Line: 222

   select legislation_code from hxc_approval_styles
    where approval_style_id = p_object_id;

Line: 226

   select legislation_code from hxc_time_entry_rules
    where time_entry_rule_id = p_object_id;

Line: 280

            'SELECT hsbl.owner_application_id, hsbl.hxc_required, hrl.meaning code_level_required,
                   faptl.application_name, hsbl.created_by, hsbl.creation_date,
                   hsbl.last_updated_by, hsbl.last_update_date, hsbl.last_update_login
              FROM hxc_seeddata_by_level hsbl,
                   hr_lookups hrl,
                   fnd_application fap,
                   fnd_application_tl faptl
             WHERE hsbl.object_id = :p_object_id
               AND hsbl.object_type = :p_object_type
               AND hrl.lookup_type = ''HXC_REQUIRED''
               AND hrl.lookup_code = hsbl.hxc_required
               AND fap.application_id = hsbl.owner_application_id
               AND faptl.APPLICATION_ID = fap.application_id
			   AND faptl.LANGUAGE = USERENV (''LANG'')';

Line: 303

		      last_updated_by        number(15),
		      last_update_date       date,
		      last_update_login      number(15)
		      );

Line: 322

		  	l_query := 'select value,id from ('||l_query||') where value like :p_value';

Line: 372

				p_seeddata_by_level_data (l_index).last_updated_by := l_seed_rec.last_updated_by;

Line: 373

				p_seeddata_by_level_data (l_index).last_update_date := l_seed_rec.last_update_date;

Line: 374

				p_seeddata_by_level_data (l_index).last_update_login := l_seed_rec.last_update_login;

Line: 382

			     -- if so we will delete this record
                if p_application_name is not null or p_code_level_required is not null then
	         	    p_seeddata_by_level_data.delete(l_index);