DBA Data[Home] [Help]

APPS.BIM_BUDGETS_DENORM_PKG dependencies on AMS_CATEGORIES_B

Line 185: FROM ams_categories_b a

181:
182: DELETE bim_i_budgets_denorm
183: WHERE object_id IN
184: (SELECT category_id
185: FROM ams_categories_b a
186: WHERE arc_category_created_for='FUND'
187: AND last_update_date > l_temp_start_date
188: AND NOT EXISTS
189: (SELECT 1

Line 266: FROM ams_categories_b a

262: ,-1
263: ,'CATEGORY'
264: ,0
265: ,'N'
266: FROM ams_categories_b a
267: WHERE arc_category_created_for='FUND'
268: AND NOT EXISTS
269: (SELECT 1
270: FROM bim_i_budgets_denorm b