APPS.HXC_APPROVAL_REPORT_PKG SQL Statements

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

Line: 28

  select full_name into l_person_name
  from per_all_people_f
  where person_id = to_number(p_person_id);

Line: 62

select max(htau_last_aprv.time_attribute_id ) INTO l_last_approver_id
from
hxc_time_building_blocks htb,
hxc_time_attribute_usages htau_last_aprv,
hxc_time_attributes hta_last_aprv
where
htb.time_building_block_id = p_timecard_id
and htb.object_version_number = p_timecard_ovn
and htb.time_building_block_id = htau_last_aprv.time_building_block_id
and htb.object_version_number = htau_last_aprv.time_building_block_ovn
and htau_last_aprv.time_attribute_id = hta_last_aprv.time_attribute_id
and hta_last_aprv.attribute_category = 'APPROVAL'
and hta_last_aprv.attribute4 = 'FINISHED' ;

Line: 78

   select attribute3 into l_last_approver from hxc_time_attributes
   where time_attribute_id = l_last_approver_id ;

Line: 107

   select project_name into l_project_name
   from pa_online_projects_v
   where project_number = p_project_number;

Line: 134

   select task_name into l_task_name
   from pa_online_tasks_v
   where task_number = p_task_number;

Line: 161

   	-- select pet.element_name into l_element_name
        -- from pay_element_types_f  pet
        -- where to_char(pet.element_type_id) = p_element_type_id;

Line: 165

        select pet.element_name into l_element_name
        from pay_element_types_f  pet
        where pet.element_type_id = to_number(p_element_type_id);

Line: 193

       select fav.application_name into l_application_name
       from hxc_time_recipients htr,fnd_application_vl fav
       where
       to_char(htr.time_recipient_id) = p_time_recipient_id
       and fav.application_id = htr.application_id;

Line: 226

  select supervisor_id into l_supervisor_id
  from per_assignments_f
  where person_id = p_person_id;

Line: 232

  	select full_name into l_person_name
  	from per_all_people_f
	 where person_id = l_supervisor_id ;

Line: 264

  select organization_id into l_organization_id
  from per_assignments_f
  where person_id = p_person_id;

Line: 269

  	select name into l_organization_name
  	from per_organization_units
	where  organization_id = l_organization_id ;

Line: 300

  select soft_coding_keyflex_id into l_flex_id
  from per_assignments_f
  where person_id = p_person_id;

Line: 305

  	select  CONCATENATED_SEGMENTS    into l_cost_center
  	from pay_cost_allocation_keyflex
	where  cost_allocation_keyflex_id = l_flex_id ;

Line: 326

  select payroll_id into l_payroll_id
  from per_assignments_f
  where person_id = p_person_id;

Line: 331

  	select payroll_name into l_payroll_name
  	from pay_all_payrolls_f
	where  payroll_id= l_payroll_id ;

Line: 352

  select business_group_id into l_bg_id
  from per_all_people_f
  where person_id = p_person_id;

Line: 357

   	select name into l_bg_name
   	from per_business_groups
   	where business_group_id = l_bg_id;