APPS.AMS_APPROVAL_UTIL_PVT dependencies on OZF_ACT_BUDGETS

Line 173: FROM ozf_act_budgets

169: CURSOR c_budget_source_owner IS
170: SELECT owner
171: from ozf_funds_all_b
172: WHERE fund_id IN (SELECT budget_source_id
173: FROM ozf_act_budgets
174: WHERE activity_budget_id = l_activity_id);
175: */
176: CURSOR c_budget_source_owner IS
177: SELECT f.owner

Line 178: FROM ozf_funds_all_b f, ozf_act_budgets a

174: WHERE activity_budget_id = l_activity_id);
175: */
176: CURSOR c_budget_source_owner IS
177: SELECT f.owner
178: FROM ozf_funds_all_b f, ozf_act_budgets a
179: WHERE f.fund_id = a.budget_source_id
180: AND a.activity_budget_id = l_activity_id;
181:
182: BEGIN

Line 275: FROM ozf_act_budgets

271: SELECT B.owner
272: FROM ozf_funds_all_b A, ozf_funds_all_b B
273: WHERE A.parent_fund_id = B.fund_id
274: AND B.fund_id IN (SELECT budget_source_id
275: FROM ozf_act_budgets
276: WHERE activity_budget_id = l_activity_id);
277:
278:
279: BEGIN