DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on AMS_CAMPAIGNS_VL

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

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

Line 2808: FROM ams_campaigns_vl

2804: ELSE
2805: IF p_object_type = 'CAMP' THEN
2806: OPEN l_obj_details FOR
2807: SELECT budget_amount_tc,owner_user_id
2808: FROM ams_campaigns_vl
2809: WHERE campaign_id = p_object_id;
2810: ELSIF p_object_type = 'CSCH' THEN
2811: OPEN l_obj_details FOR
2812: SELECT budget_amount_tc,owner_user_id