DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_NL_BILL_RATE_OVERRIDES

Line 1480: FROM pa_nl_bill_rate_overrides nlr

1476:
1477: BEGIN
1478: SELECT 'Y' into lv_return_flag from dual
1479: where exists (select null
1480: FROM pa_nl_bill_rate_overrides nlr
1481: /* where nvl(nlr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1482: where nlr.project_id = p_project_id
1483: and nlr.project_id IS NOT NULL
1484: and nlr.rate_currency_code <> lv_projfunc_currency);

Line 1569: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t

1565:
1566: BEGIN
1567: SELECT 'Y' into lv_return_flag from dual
1568: where exists (select null
1569: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t
1570: where t.project_id = p_project_id
1571: /* and nvl(nlr.task_id,-99) = t.task_id Modifed on 20/12/2002 */
1572: and nlr.task_id = t.task_id
1573: and nlr.task_id IS NOT NULL