APPS.OZF_FUND_EXTENSION_PVT dependencies on OZF_ACT_BUDGETS

Line 201: FROM ozf_act_budgets

197: l_actbudget_tbl ams_utility_pvt.dependent_objects_tbl_type;
198:
199: CURSOR c_get_actbudget_usedby IS
200: SELECT arc_act_budget_used_by, act_budget_used_by_id, status_code
201: FROM ozf_act_budgets
202: WHERE budget_source_type = 'FUND'
203: AND budget_source_id = p_object_id
204: AND transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZED');
205:

Line 208: FROM ozf_act_budgets

204: AND transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZED');
205:
206: CURSOR c_get_actbudget_source IS
207: SELECT budget_source_type, budget_source_id, status_code
208: FROM ozf_act_budgets
209: WHERE arc_act_budget_used_by = 'FUND'
210: AND act_budget_used_by_id = p_object_id
211: AND transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZED');
212:

Line 943: DELETE FROM ozf_act_budgets

939: WHERE ACTIVITY_METRIC_ID = metric_rec.activity_metric_id;
940: END LOOP;
941:
942: -- delete transaction data
943: DELETE FROM ozf_act_budgets
944: WHERE (budget_source_type = 'FUND'
945: AND budget_source_id = p_object_id
946: OR arc_act_budget_used_by = 'FUND'
947: AND act_budget_used_by_id = p_object_id