[Home] [Help]
491: AND e.project_id = X2_project_id
492: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
493: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)
494: AND NOT EXISTS ( select '1'
495: from pa_billing_assignments bea,
496: pa_billing_extensions be
497: where be.billing_extension_id = bea.billing_extension_id
498: and bea.billing_assignment_id = e.billing_assignment_id
499: and be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt');
519: AND e.project_id = X2_project_id
520: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
521: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)
522: AND NOT EXISTS ( select '1'
523: from pa_billing_assignments bea,
524: pa_billing_extensions be
525: where be.billing_extension_id = bea.billing_extension_id
526: and bea.billing_assignment_id = e.billing_assignment_id
527: and be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt'); */
662: CURSOR pctfunc_revenue(X2_project_id Number,X2_task_id Number) IS
663: SELECT NVL(e.bill_trans_rev_amount,0) trans_rev_amount,e.bill_trans_currency_code,
664: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
665: FROM pa_events e,
666: pa_billing_assignments bea,
667: pa_billing_extensions be
668: where be.billing_extension_id = bea.billing_extension_id
669: and e.project_id = X2_project_id
670: and nvl(e.task_id,0) =
688: AND nvl(dri.task_id,0) = decode(X2_task_id, NULL, nvl(dri.task_id,0), X2_task_id )
689: AND (EXISTS ( select '1'
690: from pa_cust_event_rev_dist_lines erdl,
691: pa_events e,
692: pa_billing_assignments bea,
693: pa_billing_extensions be
694: where be.billing_extension_id = bea.billing_extension_id
695: and bea.billing_assignment_id = e.billing_assignment_id
696: and e.project_id = erdl.project_id
713: /*
714: SELECT sum(nvl(e.revenue_amount,0))
715: INTO pending_pctrev
716: FROM pa_events e,
717: pa_billing_assignments bea,
718: pa_billing_extensions be
719: where be.billing_extension_id = bea.billing_extension_id
720: and e.project_id = X2_project_id
721: and nvl(e.task_id,0) =
853: CURSOR pctfunc_invoice(X2_project_id Number,X2_task_id Number) IS
854: SELECT NVL(e.bill_trans_bill_amount,0) trans_bill_amount,e.bill_trans_currency_code,e.projfunc_currency_code,
855: e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
856: FROM pa_events e,
857: pa_billing_assignments bea,
858: pa_billing_extensions be
859: WHERE be.billing_extension_id = bea.billing_extension_id
860: AND bea.billing_assignment_id = e.billing_assignment_id
861: AND e.project_id = X2_project_id
881: /*
882: SELECT sum(nvl(e.bill_amount,0))
883: INTO pending_ccinv
884: from pa_events e,
885: pa_billing_assignments bea,
886: pa_billing_extensions be
887: where be.billing_extension_id = bea.billing_extension_id
888: and bea.billing_assignment_id = e.billing_assignment_id
889: and e.project_id = X2_project_id
970: FROM pa_draft_invoice_items dii
971: WHERE dii.project_id = X2_project_id
972: AND (EXISTS (select '1'
973: from pa_events e,
974: pa_billing_assignments bea,
975: pa_billing_extensions be
976: where be.billing_extension_id = bea.billing_extension_id
977: and bea.billing_assignment_id = e.billing_assignment_id
978: and dii.project_id = e.project_id
1015: WHERE pdii.event_task_id = X2_task_id
1016: AND pdii.Project_ID = X2_Project_ID -- Perf Bug 2695332
1017: AND EXISTS (select '1'
1018: from pa_events e,
1019: pa_billing_assignments bea,
1020: pa_billing_extensions be
1021: where be.billing_extension_id = bea.billing_extension_id
1022: and bea.billing_assignment_id = e.billing_assignment_id
1023: and pdii.project_id = e.project_id