DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on WIP_EMPLOYEE_LABOR_RATES

Line 3371: from wip_employee_labor_rates

3367: p_org_id number,
3368: p_emp_id number,
3369: p_txn_date date) is
3370: select hourly_labor_rate
3371: from wip_employee_labor_rates
3372: where employee_id = p_emp_id
3373: and organization_id = p_org_id
3374: and effective_date =
3375: (select max(effective_date)

Line 3376: from wip_employee_labor_rates

3372: where employee_id = p_emp_id
3373: and organization_id = p_org_id
3374: and effective_date =
3375: (select max(effective_date)
3376: from wip_employee_labor_rates
3377: where employee_id = p_emp_id
3378: and organization_id = p_org_id
3379: and effective_date <= trunc(p_txn_date));
3380: begin