[Home] [Help]
494: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
495: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)
496: AND NOT EXISTS ( select '1'
497: from pa_billing_assignments bea,
498: pa_billing_extensions be
499: where be.billing_extension_id = bea.billing_extension_id
500: and bea.billing_assignment_id = e.billing_assignment_id
501: and be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt');
502:
522: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
523: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)
524: AND NOT EXISTS ( select '1'
525: from pa_billing_assignments bea,
526: pa_billing_extensions be
527: where be.billing_extension_id = bea.billing_extension_id
528: and bea.billing_assignment_id = e.billing_assignment_id
529: and be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt'); */
530:
665: SELECT NVL(e.bill_trans_rev_amount,0) trans_rev_amount,e.bill_trans_currency_code,
666: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
667: FROM pa_events e,
668: pa_billing_assignments bea,
669: pa_billing_extensions be
670: where be.billing_extension_id = bea.billing_extension_id
671: and e.project_id = X2_project_id
672: and nvl(e.task_id,0) =
673: decode(X2_task_id,
691: AND (EXISTS ( select '1'
692: from pa_cust_event_rev_dist_lines erdl,
693: pa_events e,
694: pa_billing_assignments bea,
695: pa_billing_extensions be
696: where be.billing_extension_id = bea.billing_extension_id
697: and bea.billing_assignment_id = e.billing_assignment_id
698: and e.project_id = erdl.project_id
699: and e.event_num = erdl.event_num
716: SELECT sum(nvl(e.revenue_amount,0))
717: INTO pending_pctrev
718: FROM pa_events e,
719: pa_billing_assignments bea,
720: pa_billing_extensions be
721: where be.billing_extension_id = bea.billing_extension_id
722: and e.project_id = X2_project_id
723: and nvl(e.task_id,0) =
724: decode(X2_task_id,
856: SELECT NVL(e.bill_trans_bill_amount,0) trans_bill_amount,e.bill_trans_currency_code,e.projfunc_currency_code,
857: e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
858: FROM pa_events e,
859: pa_billing_assignments bea,
860: pa_billing_extensions be
861: WHERE be.billing_extension_id = bea.billing_extension_id
862: AND bea.billing_assignment_id = e.billing_assignment_id
863: AND e.project_id = X2_project_id
864: AND be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt'
884: SELECT sum(nvl(e.bill_amount,0))
885: INTO pending_ccinv
886: from pa_events e,
887: pa_billing_assignments bea,
888: pa_billing_extensions be
889: where be.billing_extension_id = bea.billing_extension_id
890: and bea.billing_assignment_id = e.billing_assignment_id
891: and e.project_id = X2_project_id
892: and be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt'
973: WHERE dii.project_id = X2_project_id
974: AND (EXISTS (select '1'
975: from pa_events e,
976: pa_billing_assignments bea,
977: pa_billing_extensions be
978: where be.billing_extension_id = bea.billing_extension_id
979: and bea.billing_assignment_id = e.billing_assignment_id
980: and dii.project_id = e.project_id
981: and dii.event_num = e.event_num
1018: AND pdii.Project_ID = X2_Project_ID -- Perf Bug 2695332
1019: AND EXISTS (select '1'
1020: from pa_events e,
1021: pa_billing_assignments bea,
1022: pa_billing_extensions be
1023: where be.billing_extension_id = bea.billing_extension_id
1024: and bea.billing_assignment_id = e.billing_assignment_id
1025: and pdii.project_id = e.project_id
1026: and pdii.event_num = e.event_num
1174: DECODE(P_rev_plan_type_id,NULL,default_rev_plan_type_id,
1175: P_rev_plan_type_id) /* Added for fin plan type id */
1176: INTO l_rev_budget_type_code,
1177: l_rev_plan_type_id
1178: FROM pa_billing_extensions
1179: WHERE billing_extension_id=pa_billing.GetBillingExtensionId;
1180:
1181: IF g1_debug_mode = 'Y' THEN
1182: PA_MCB_INVOICE_PKG.log_message(' getting l_rev_budget_type_code inside pa_bill_pct.get_rev_budget_amount: '||l_rev_budget_type_code);