APPS.HXC_TERG_UPL_PKG SQL Statements

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

Line: 11

     SELECT TIME_ENTRY_RULE_GROUP_ID,
	    OBJECT_VERSION_NUMBER
       INTO l_time_entry_rule_group_id,
	    l_ovn
       FROM HXC_TIME_ENTRY_RULE_GROUPS_V
      WHERE TIME_ENTRY_RULE_GROUP_NAME = p_time_entry_rule_group_name;

Line: 73

     /*select time_entry_rule_group_id
       from hxc_time_entry_rule_groups_v
      where time_entry_rule_group_name = p_time_entry_group_name;*/

Line: 76

     select entity_group_id
       from hxc_entity_groups
      where entity_type = 'TIME_ENTRY_RULES'
	and name = p_time_entry_group_name;

Line: 92

    select time_entry_rule_id
      from hxc_time_entry_rules
     where name = p_time_entry_rule_name;

Line: 106

   select lookup_code
     from hr_lookups
    where lookup_type = 'HXC_TIME_ENTRY_RULE_OUTCOME' and
          meaning = p_meaning;

Line: 121

     SELECT  htc.ENTITY_GROUP_COMP_ID   ,
	     htc.ENTITY_GROUP_ID        ,
	     htc.ENTITY_ID              ,
	     htc.ENTITY_TYPE            ,
	     htc.ATTRIBUTE_CATEGORY     ,
	     htc.ATTRIBUTE1             ,
	     htc.ATTRIBUTE2             ,
	     htc.ATTRIBUTE3             ,
	     htc.ATTRIBUTE4             ,
 	     htc.ATTRIBUTE5             ,
	     htc.ATTRIBUTE6             ,
	     htc.ATTRIBUTE7             ,
	     htc.ATTRIBUTE8             ,
	     htc.ATTRIBUTE9             ,
	     htc.ATTRIBUTE10            ,
	     htc.ATTRIBUTE11            ,
	     htc.ATTRIBUTE12            ,
	     htc.ATTRIBUTE13            ,
	     htc.ATTRIBUTE14            ,
	     htc.ATTRIBUTE15            ,
	     htc.ATTRIBUTE16            ,
	     htc.ATTRIBUTE17            ,
	     htc.ATTRIBUTE18            ,
	     htc.ATTRIBUTE19            ,
	     htc.ATTRIBUTE20            ,
	     htc.ATTRIBUTE21            ,
	     htc.ATTRIBUTE22            ,
	     htc.ATTRIBUTE23            ,
	     htc.ATTRIBUTE24            ,
	     htc.ATTRIBUTE25            ,
	     htc.ATTRIBUTE26            ,
	     htc.ATTRIBUTE27            ,
	     htc.ATTRIBUTE28            ,
	     htc.ATTRIBUTE29            ,
	     htc.ATTRIBUTE30            ,
	     htc.OBJECT_VERSION_NUMBER
	INTO l_time_entry_rule_comp_id ,
	     l_time_entry_rule_group_id ,
	     l_entity_id ,
	     l_entity_type,
	     l_attribute_category,
	     l_outcome,
	     l_attribute2,
	     l_attribute3,
	     l_attribute4,
	     l_attribute5,
	     l_attribute6,
	     l_attribute7,
	     l_attribute8,
	     l_attribute9,
	     l_attribute10,
	     l_attribute11,
	     l_attribute12,
	     l_attribute13,
	     l_attribute14,
	     l_attribute15,
	     l_attribute16,
	     l_attribute17,
	     l_attribute18,
	     l_attribute19,
	     l_attribute20,
	     l_attribute21,
	     l_attribute22,
	     l_attribute23,
	     l_attribute24,
	     l_attribute25,
	     l_attribute26,
	     l_attribute27,
	     l_attribute28,
	     l_attribute29,
	     l_attribute30,
	     l_ovn
       FROM  HXC_ENTITY_GROUPS HTE,
             HXC_ENTITY_GROUP_COMPS HTC
      WHERE  HTC.ENTITY_GROUP_ID = HTE.ENTITY_GROUP_ID AND
	     HTE.ENTITY_GROUP_ID = l_time_entry_rule_group_id AND
             HTC.ENTITY_ID = l_entity_id ;