APPS.AMS_APPROVAL_UTIL_PVT dependencies on OZF_FUNDS_ALL_B

Line 164: FROM ozf_funds_all_b

160: l_activity_id NUMBER;
161:
162: CURSOR c_fund_owner IS
163: SELECT owner
164: FROM ozf_funds_all_b
165: WHERE fund_id = l_budget_id;
166:
167: -- Change for SQL Repository Perf Fix
168: /*

Line 171: from ozf_funds_all_b

167: -- Change for SQL Repository Perf Fix
168: /*
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: */

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 265: FROM ozf_funds_all_b A, ozf_funds_all_b B

261: l_owner_id NUMBER;
262:
263: CURSOR c_parent_fund_owner IS
264: SELECT B.owner
265: FROM ozf_funds_all_b A, ozf_funds_all_b B
266: WHERE A.parent_fund_id = B.fund_id
267: AND B.fund_id = l_activity_id;
268:
269: CURSOR c_budget_source_par_owner IS

Line 272: FROM ozf_funds_all_b A, ozf_funds_all_b B

268:
269: CURSOR c_budget_source_par_owner IS
270: -- Will return owner if budget is a parent
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);