PA Timecard Entry

Description
Categories: BI Publisher, Financials
Application: Projects
Source: AUD: Timecard Entry (XML)
Short Name: PAXPCTCE_XML
DB package: PA_PAXPCTCE_XMLP_PKG
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 */
Parameter Name SQL text Validation
Include Routing History
 
LOV Oracle
Set of Books Currency
 
LOV Oracle
Incurred By Organization
 
LOV Oracle
Employee Name
 
LOV Oracle
Week Ending Date To
 
Date
Week Ending Date From
 
Date
Ask a question