PA Employee Activity By Organization

select 
      v.assigned_to_organization_id	prj_org_id
,     substr(v.assigned_to_organization_name,1,60)  assigned_to_organization_name  
,     v.incurred_by_name  
,     v.incurred_by_employee_num incurred_by_employee_num_1
,     v.job_name job_name_1               
,     v.project_number      
,     v.project_name
,     sum(v.total_hours) total_hours
,     sum(v.billable_hours) billable_hours
,     sum(v.non_billable_hours) non_billable_hours,
--PA_PAXEMRAO_XMLP_PKG.c_org_utilizationformula(:c_org_tot_hours, :c_org_tot_billable) c_org_utilization,
PA_PAXEMRAO_XMLP_PKG.c_utilizationformula(sum(v.total_hours), sum(v.billable_hours)) c_utilization
--PA_PAXEMRAO_XMLP_PKG.c_project_utilizationformula(:C_pr_tot_ho,:C_p_tot_bi) c_project_utilization 
from
     pa_labor_expenditures_view v
WHERE
         v.incurred_by_person_id = 
            nvl(:p_person_id, v.incurred_by_person_id)
and   v.expenditure_item_date between :date_lo and :date_hi 
 and v.assigned_to_organization_id=:organization_id
Group by v.assigned_to_organization_id,
                v.assigned_to_organization_name,
                v.incurred_by_name,
                v.incurred_by_employee_num,
                v.job_name,
                v.project_number,
                v.project_name
/*Order by v.assigned_to_organization_name,
         v.incurred_by_name,
         v.project_number */
Order by v.assigned_to_organization_id,v.incurred_by_name,v.incurred_by_employee_num,v.job_name,     v.project_number,v.project_name

select v.assigned_to_organization_id prj_org_id , substr(v.assigned_to_organization_name,1,60) assigned_to_organization_name , v.incurred_by_name , v.incurred_by_employee_num incurred_by_employee_num_1 , v.job_name job_name_1 , v.project_number , v.project_name , sum(v.total_hours) total_hours , sum(v.billable_hours) billable_hours , sum(v.non_billable_hours) non_billable_hours, --PA_PAXEMRAO_XMLP_PKG.c_org_utilizationformula(:c_org_tot_hours, :c_org_tot_billable) c_org_utilization, PA_PAXEMRAO_XMLP_PKG.c_utilizationformula(sum(v.total_hours), sum(v.billable_hours)) c_utilization --PA_PAXEMRAO_XMLP_PKG.c_project_utilizationformula(:C_pr_tot_ho,:C_p_tot_bi) c_project_utilization from pa_labor_expenditures_view v WHERE v.incurred_by_person_id = nvl(:p_person_id, v.incurred_by_person_id) and v.expenditure_item_date between :date_lo and :date_hi and v.assigned_to_organization_id=:organization_id Group by v.assigned_to_organization_id, v.assigned_to_organization_name, v.incurred_by_name, v.incurred_by_employee_num, v.job_name, v.project_number, v.project_name /*Order by v.assigned_to_organization_name, v.incurred_by_name, v.project_number */ Order by v.assigned_to_organization_id,v.incurred_by_name,v.incurred_by_employee_num,v.job_name, v.project_number,v.project_name