[Home] [Help]
222: CURSOR func_revenue(X2_project_id Number,X2_task_id Number) IS
223: SELECT NVL(e.bill_trans_rev_amount,0) trans_rev_amount,e.bill_trans_currency_code,
224: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
225: FROM pa_events e,
226: pa_billing_assignments bea,
227: pa_billing_extensions be
228: where be.billing_extension_id = bea.billing_extension_id
229: and e.project_id = X2_project_id
230: and nvl(e.task_id,0) = decode(X2_task_id,NULL,nvl(e.task_id,0), X2_task_id )
246: AND nvl(dri.task_id,0) = decode(X2_task_id, NULL, nvl(dri.task_id,0), X2_task_id )
247: AND (EXISTS ( select '1'
248: from pa_cust_event_rev_dist_lines erdl,
249: pa_events e,
250: pa_billing_assignments bea,
251: pa_billing_extensions be
252: where be.billing_extension_id = bea.billing_extension_id
253: and bea.billing_assignment_id = e.billing_assignment_id
254: and e.project_id = erdl.project_id
269: */
270: /* SELECT sum(nvl(e.revenue_amount,0))
271: INTO pending_ccrev
272: FROM pa_events e,
273: pa_billing_assignments bea,
274: pa_billing_extensions be
275: where be.billing_extension_id = bea.billing_extension_id
276: and e.project_id = X2_project_id
277: and nvl(e.task_id,0) =
418: AND e.project_id = X2_project_id
419: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
420: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)
421: AND NOT EXISTS ( select 'cost-cost event'
422: from pa_billing_assignments bea,
423: pa_billing_extensions be
424: where be.billing_extension_id = bea.billing_extension_id
425: and bea.billing_assignment_id = e.billing_assignment_id
426: and be.procedure_name = 'pa_billing.ccrev');
444: AND e.project_id = X2_project_id
445: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
446: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)
447: AND NOT EXISTS ( select 'cost-cost event'
448: from pa_billing_assignments bea,
449: pa_billing_extensions be
450: where be.billing_extension_id = bea.billing_extension_id
451: and bea.billing_assignment_id = e.billing_assignment_id
452: and be.procedure_name = 'pa_billing.ccrev'); */
588: SELECT NVL(e.bill_trans_bill_amount,0) trans_bill_amount,e.bill_trans_currency_code,
589: e.projfunc_currency_code,
590: e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
591: FROM pa_events e,
592: pa_billing_assignments bea,
593: pa_billing_extensions be
594: WHERE be.billing_extension_id = bea.billing_extension_id
595: AND bea.billing_assignment_id = e.billing_assignment_id
596: AND e.project_id = X2_project_id
618: /*
619: SELECT sum(nvl(e.bill_amount,0))
620: INTO pending_ccinv
621: from pa_events e,
622: pa_billing_assignments bea,
623: pa_billing_extensions be
624: where be.billing_extension_id = bea.billing_extension_id
625: and bea.billing_assignment_id = e.billing_assignment_id
626: and e.project_id = X2_project_id
707: FROM pa_draft_invoice_items dii
708: WHERE dii.project_id = X2_project_id
709: AND (EXISTS (select '1'
710: from pa_events e,
711: pa_billing_assignments bea,
712: pa_billing_extensions be
713: where be.billing_extension_id = bea.billing_extension_id
714: and bea.billing_assignment_id = e.billing_assignment_id
715: and dii.project_id = e.project_id
748: WHERE pdii.event_task_id = X2_task_id
749: AND pdii.Project_ID = X2_Project_ID -- Perf Bug 2695243
750: AND EXISTS (select '1'
751: from pa_events e,
752: pa_billing_assignments bea,
753: pa_billing_extensions be
754: where be.billing_extension_id = bea.billing_extension_id
755: and bea.billing_assignment_id = e.billing_assignment_id
756: and pdii.project_id = e.project_id