APPS.AMS_ACT_LIST_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 1111: from ams_act_lists a, ams_event_offers_vl b

1107: and a.list_used_by = 'CSCH'
1108: and b.status_code = 'ACTIVE'
1109: union
1110: select 'x'
1111: from ams_act_lists a, ams_event_offers_vl b
1112: where p_act_list_header_id = p_act_list_header_id
1113: and a.list_used_by_id = b.event_offer_id
1114: and a.list_used_by in('EVEO','EONE')
1115: and b.system_status_code = 'ACTIVE';