APPS.BIM_POPDATES_PKG dependencies on AMS_EVENT_OFFERS_ALL_B

Line 66: ams_event_offers_all_b c

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
70: and c.event_header_id = b.event_header_id );