APPS.BIM_POPDATES_PKG dependencies on AMS_CAMPAIGNS_ALL_B

Line 45: ams_campaigns_all_b b

41: AND bu2.budget_source_id = o.fund_id
42: union all
43: SELECT min(a.approval_date) de
44: FROM ozf_act_budgets a,
45: ams_campaigns_all_b b
46: WHERE a.budget_source_type ='FUND'
47: AND a.ARC_ACT_BUDGET_USED_BY = 'CAMP'
48: AND a.status_code ='APPROVED'
49: and a.act_budget_used_by_id=b.campaign_id