DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_BILLING_ASSIGNMENTS

Line 1449: from pa_billing_assignments asg

1445:
1446: BEGIN
1447: SELECT 'Y' into lv_return_flag from dual
1448: where exists (select null
1449: from pa_billing_assignments asg
1450: /* where nvl(asg.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002*/
1451: where asg.project_id = p_project_id
1452: and asg.project_id IS NOT NULL
1453: and asg.rate_override_currency_code <> lv_projfunc_currency);

Line 1534: from pa_billing_assignments asg, pa_tasks t

1530:
1531: BEGIN
1532: SELECT 'Y' into lv_return_flag from dual
1533: where exists (select null
1534: from pa_billing_assignments asg, pa_tasks t
1535: where t.project_id = p_project_id
1536: /* and nvl(asg.top_task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1537: and asg.top_task_id = t.task_id
1538: and asg.project_id = t.project_id -- added for bug 3517177