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);
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