68:
69:
70:
71: /* ----------------------------------------------------------------------
72: Get the Cost and Revenue Budget Type code from pa_billing_extensions
73: ---------------------------------------------------------------------- */
74:
75: l_cost_budget_type_code := P_cost_budget_type_code ;
76: l_rev_budget_type_code := P_rev_budget_type_code ;
82: decode(P_rev_budget_type_code,NULL,default_rev_budget_type_code,
83: P_rev_budget_type_code)
84: INTO l_cost_budget_type_code,
85: l_rev_budget_type_code
86: FROM pa_billing_extensions
87: WHERE billing_extension_id= p_billing_Extension_Id;
88:
89: END IF;
90:
820: SELECT SUM(NVL(mcevt.revenue_amount,0)) revenue_amount
821: INTO l_mc_revenue_amount
822: FROM pa_events e, pa_mc_events mcevt,
823: pa_billing_assignments bea,
824: pa_billing_extensions be
825: WHERE be.billing_extension_id = bea.billing_extension_id
826: AND e.project_id = p_project_id
827: AND nvl(e.task_id,-1) = nvl(p_task_id, nvl(e.task_id, -1))
828: AND e.event_id = mcevt.event_id
846: SELECT sum(nvl(mcerdl.amount,0))
847: INTO l_erdl_accrued_amount
848: FROM pa_draft_revenue_items dri, pa_mc_cust_event_rdl_all mcerdl,
849: pa_events e, pa_billing_assignments bea,
850: pa_billing_extensions be
851: WHERE dri.project_id = p_project_id
852: AND NVL(dri.task_id,-1) = NVL(p_task_id, nvl(dri.task_id, -1))
853: AND mcerdl.project_id = dri.project_id
854: AND NVL(mcerdl.task_id, -1) = NVL(dri.task_id, -1)