DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 1504: FROM pa_emp_bill_rate_overrides emp

1500:
1501: BEGIN
1502: SELECT 'Y' into lv_return_flag from dual
1503: where exists (select null
1504: FROM pa_emp_bill_rate_overrides emp
1505: /* where nvl(emp.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1506: where emp.project_id = p_project_id
1507: and emp.project_id IS NOT NULL
1508: and emp.rate_currency_code <> lv_projfunc_currency);

Line 1594: FROM pa_emp_bill_rate_overrides emp, pa_tasks t

1590:
1591: BEGIN
1592: SELECT 'Y' into lv_return_flag from dual
1593: where exists (select null
1594: FROM pa_emp_bill_rate_overrides emp, pa_tasks t
1595: where t.project_id = p_project_id
1596: /* and nvl(emp.task_id,-99) = t.task_id Modifed on 20/12/2002*/
1597: and emp.task_id = t.task_id
1598: and emp.task_id IS NOT NULL