DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_JOB_BILL_RATE_OVERRIDES

Line 1471: FROM pa_job_bill_rate_overrides jbr

1467:
1468: BEGIN
1469: SELECT 'Y' into lv_return_flag from dual
1470: where exists (select null
1471: FROM pa_job_bill_rate_overrides jbr
1472: /* where nvl(jbr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1473: where jbr.project_id = p_project_id
1474: and jbr.project_id IS NOT NULL
1475: and jbr.rate_currency_code <> lv_projfunc_currency);

Line 1559: FROM pa_job_bill_rate_overrides jbr, pa_tasks t

1555:
1556: BEGIN
1557: SELECT 'Y' into lv_return_flag from dual
1558: where exists (select null
1559: FROM pa_job_bill_rate_overrides jbr, pa_tasks t
1560: where t.project_id = p_project_id
1561: /* and nvl(jbr.task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1562: and jbr.task_id = t.task_id
1563: and jbr.task_id IS NOT NULL