DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 1497: FROM pa_emp_bill_rate_overrides emp

1493:
1494: BEGIN
1495: SELECT 'Y' into lv_return_flag from dual
1496: where exists (select null
1497: FROM pa_emp_bill_rate_overrides emp
1498: /* where nvl(emp.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1499: where emp.project_id = p_project_id
1500: and emp.project_id IS NOT NULL
1501: and emp.rate_currency_code <> lv_projfunc_currency);

Line 1587: FROM pa_emp_bill_rate_overrides emp, pa_tasks t

1583:
1584: BEGIN
1585: SELECT 'Y' into lv_return_flag from dual
1586: where exists (select null
1587: FROM pa_emp_bill_rate_overrides emp, pa_tasks t
1588: where t.project_id = p_project_id
1589: /* and nvl(emp.task_id,-99) = t.task_id Modifed on 20/12/2002*/
1590: and emp.task_id = t.task_id
1591: and emp.task_id IS NOT NULL