PA Timecard Entry

Select Distinct
   exp.expenditure_class_code expenditure_class_code1,
   nvl(per.employee_number,per.npw_number)  employee_number ,
   per.full_name  Employee_Name,
   src.user_transaction_source Expenditure_class_code,
   exp.expenditure_id emp_exp_id,
   exp.Initial_submission_date,
   exp.expenditure_ending_date,
   exp.description expenditure_comments,
   exp.denom_currency_code
from
     per_people_f                  per,
     pa_expenditures               exp,
          pa_expenditure_items_all       pei,
          pa_transaction_sources src
where
    per.person_id between nvl(:Employee_id,0) and
                          nvl(:Employee_id,999999999999999) and
    sysdate between per.effective_start_date and
                                    nvl(per.effective_end_date,sysdate + 1) and
    (per.employee_number IS NOT NULL or per.npw_number IS NOT NULL) and 
    exp.expenditure_ending_date between :date_low and :date_high and
    exp.incurred_by_organization_id =
    nvl(:incurred_org,exp.incurred_by_organization_id) and
    exp.incurred_by_person_id = per.person_id and
    exp.expenditure_class_code in ('OT','PT')  and
    exp.expenditure_id = nvl(:exp_id,exp.expenditure_id) and
    exp.expenditure_id = pei.expenditure_id and
    exp.expenditure_status_code <> 'WORKING' and
    pei.transaction_source = src.transaction_source(+)
	order by exp.expenditure_ending_date  /* Added order by for bug 17078532 */