DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on PV_RESOURCE_INFO_V

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: