APPS.AST_OFL_EVENT_INFO_PARAM dependencies on AMS_EVENT_OFFERS_VL

Line 344: FROM ams_event_offers_vl

340:
341: CURSOR cur_promotion_code(Event_Code VARCHAR2) is
342: -- RN 25/9/00
343: SELECT event_offer_id code, event_offer_name name
344: FROM ams_event_offers_vl
345: WHERE event_offer_id LIKE NVL(UPPER(Event_Code), '%') || '%'
346: OR UPPER(event_offer_name) LIKE NVL(UPPER(Event_Code), '%') || '%'
347: -- select code, name
348: -- from as_promotions_all

Line 428: FROM ams_event_offers_vl

424:
425: CURSOR cur_promotion_code(Event_Code VARCHAR2) is
426: -- RN 25/9/00
427: SELECT event_offer_id code, event_offer_name name
428: FROM ams_event_offers_vl
429: WHERE event_offer_id LIKE NVL(UPPER(Event_Code), '%') || '%'
430: OR UPPER(event_offer_name) LIKE NVL(UPPER(Event_Code), '%') || '%'
431: -- select code, name
432: -- from as_promotions_all