DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_JOB_BILL_RATE_OVERRIDES

Line 1464: FROM pa_job_bill_rate_overrides jbr

1460:
1461: BEGIN
1462: SELECT 'Y' into lv_return_flag from dual
1463: where exists (select null
1464: FROM pa_job_bill_rate_overrides jbr
1465: /* where nvl(jbr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1466: where jbr.project_id = p_project_id
1467: and jbr.project_id IS NOT NULL
1468: and jbr.rate_currency_code <> lv_projfunc_currency);

Line 1552: FROM pa_job_bill_rate_overrides jbr, pa_tasks t

1548:
1549: BEGIN
1550: SELECT 'Y' into lv_return_flag from dual
1551: where exists (select null
1552: FROM pa_job_bill_rate_overrides jbr, pa_tasks t
1553: where t.project_id = p_project_id
1554: /* and nvl(jbr.task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1555: and jbr.task_id = t.task_id
1556: and jbr.task_id IS NOT NULL