[Home] [Help]
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');
500:
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'); */
528:
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) =
671: decode(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
697: and e.event_num = erdl.event_num
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) =
722: decode(X2_task_id,
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
862: AND be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt'
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
890: and be.procedure_name = 'pa_bill_pct.calc_pct_comp_amt'
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
979: and dii.event_num = e.event_num
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
1024: and pdii.event_num = e.event_num
1172: DECODE(P_rev_plan_type_id,NULL,default_rev_plan_type_id,
1173: P_rev_plan_type_id) /* Added for fin plan type id */
1174: INTO l_rev_budget_type_code,
1175: l_rev_plan_type_id
1176: FROM pa_billing_extensions
1177: WHERE billing_extension_id=pa_billing.GetBillingExtensionId;
1178:
1179: IF g1_debug_mode = 'Y' THEN
1180: 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);