APPS.BIM_BUDGETS_DENORM_PKG dependencies on OZF_FUNDS_ALL_B

Line 172: FROM ozf_funds_all_b a

168: /* This piece of code is for the budgets that have changed from one parent to another. */
169: DELETE bim_i_budgets_denorm
170: WHERE object_id IN
171: (SELECT fund_id
172: FROM ozf_funds_all_b a
173: WHERE last_update_date > l_temp_start_date
174: AND NOT EXISTS
175: (SELECT 1
176: FROM bim_i_budgets_denorm b

Line 240: FROM ozf_funds_all_b a

236: ,-1
237: ,fund_type
238: ,category_id
239: ,'N'
240: FROM ozf_funds_all_b a
241: WHERE
242: NOT EXISTS
243: (SELECT 1
244: FROM bim_i_budgets_denorm b