APPS.PA_MC_BILLING_PVT dependencies on PA_BILLING_EXTENSIONS

Line 72: Get the Cost and Revenue Budget Type code from pa_billing_extensions

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 ;

Line 86: FROM pa_billing_extensions

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:

Line 824: pa_billing_extensions be

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

Line 850: pa_billing_extensions be

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)