DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_NL_BILL_RATE_OVERRIDES

Line 1487: FROM pa_nl_bill_rate_overrides nlr

1483:
1484: BEGIN
1485: SELECT 'Y' into lv_return_flag from dual
1486: where exists (select null
1487: FROM pa_nl_bill_rate_overrides nlr
1488: /* where nvl(nlr.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002 */
1489: where nlr.project_id = p_project_id
1490: and nlr.project_id IS NOT NULL
1491: and nlr.rate_currency_code <> lv_projfunc_currency);

Line 1576: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t

1572:
1573: BEGIN
1574: SELECT 'Y' into lv_return_flag from dual
1575: where exists (select null
1576: FROM pa_nl_bill_rate_overrides nlr, pa_tasks t
1577: where t.project_id = p_project_id
1578: /* and nvl(nlr.task_id,-99) = t.task_id Modifed on 20/12/2002 */
1579: and nlr.task_id = t.task_id
1580: and nlr.task_id IS NOT NULL