APPS.BIM_POPDATES_PKG dependencies on AMS_EVENT_REGISTRATIONS

Line 64: FROM ams_event_registrations A,

60: and b.active_from_date>p_date
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')