APPS.OZF_BUDGETAPPROVAL_PVT dependencies on AMS_CAMPAIGNS_VL

Line 411: FROM ozf_act_budgets act, ams_campaigns_vl camp, pv_resource_info_v rsc

407: CURSOR c_partner_name IS
408: SELECT act.request_amount,NVL(rsc.partner_party_name,'Partner')
409: , NVL(camp.description,''),
410: camp.source_code, TO_CHAR(camp.actual_exec_start_date),TO_CHAR(camp.actual_exec_end_date),camp.campaign_name
411: FROM ozf_act_budgets act, ams_campaigns_vl camp, pv_resource_info_v rsc
412: WHERE act.activity_budget_id = p_act_budget_rec.activity_budget_id
413: AND act.act_budget_used_by_id = camp.campaign_id
414: AND act.requester_Id = rsc.rsc_resource_id(+);
415:

Line 2812: FROM ams_campaigns_vl

2808: ELSE
2809: IF p_object_type = 'CAMP' THEN
2810: OPEN l_obj_details FOR
2811: SELECT budget_amount_tc,owner_user_id
2812: FROM ams_campaigns_vl
2813: WHERE campaign_id = p_object_id;
2814: ELSIF p_object_type = 'CSCH' THEN
2815: OPEN l_obj_details FOR
2816: SELECT budget_amount_tc,owner_user_id