DBA Data[Home] [Help]

APPS.AMS_ACTIVATE_EVENTSCHED_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 38: FROM ams_event_offers_all_b offr, ams_event_headers_all_b hdr

34: IS
35:
36: CURSOR c_all_schedule IS
37: SELECT offr.event_offer_id, offr.object_version_number,offr.event_level,offr.parent_id
38: FROM ams_event_offers_all_b offr, ams_event_headers_all_b hdr
39: WHERE offr.system_status_code = 'AVAILABLE'
40: --AND offr.reg_required_flag = 'Y'
41: --AND offr.reg_start_date <= SYSDATE
42: AND offr.event_header_id = hdr.event_header_id