DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_BILLING_ASSIGNMENTS

Line 1456: from pa_billing_assignments asg

1452:
1453: BEGIN
1454: SELECT 'Y' into lv_return_flag from dual
1455: where exists (select null
1456: from pa_billing_assignments asg
1457: /* where nvl(asg.project_id,-99) = p_project_id Bug 2702200 Modified on 20/12/2002*/
1458: where asg.project_id = p_project_id
1459: and asg.project_id IS NOT NULL
1460: and asg.rate_override_currency_code <> lv_projfunc_currency);

Line 1541: from pa_billing_assignments asg, pa_tasks t

1537:
1538: BEGIN
1539: SELECT 'Y' into lv_return_flag from dual
1540: where exists (select null
1541: from pa_billing_assignments asg, pa_tasks t
1542: where t.project_id = p_project_id
1543: /* and nvl(asg.top_task_id,-99) = t.task_id Bug 2702200 Modified on 20/12/2002 */
1544: and asg.top_task_id = t.task_id
1545: and asg.project_id = t.project_id -- added for bug 3517177