51: and b.status_code in ('ACTIVE', 'CANCELLED', 'COMPLETED','CLOSED')
52: union all
53: SELECT min(a.approval_date)
54: FROM ozf_act_budgets a,
55: ams_event_headers_all_b b
56: WHERE a.budget_source_type ='FUND'
57: AND a.ARC_ACT_BUDGET_USED_BY = 'EVEH'
58: AND a.status_code ='APPROVED'
59: and a.act_budget_used_by_id=b.event_header_id
61: and b.system_status_code in ('ACTIVE', 'CANCELLED', 'COMPLETED','CLOSED')
62: union all
63: SELECT min(a.last_reg_status_date) de
64: FROM ams_event_registrations A,
65: ams_event_headers_all_b b,
66: ams_event_offers_all_b c
67: where b.active_from_date>p_date
68: and b.system_status_code in ('ACTIVE', 'CANCELLED', 'COMPLETED')
69: and a.event_offer_id = c.event_offer_id