DBA Data[Home] [Help]

APPS.AST_OFL_EVENT_ATTENDEES_PARAM dependencies on AMS_EVENT_OFFERS_VL

Line 321: FROM ams_event_offers_vl

317: CURSOR cur_promotion_code(p_e_c varchar2)
318: IS
319: -- RN 25/9/00
320: SELECT event_offer_id code, event_offer_name name
321: FROM ams_event_offers_vl
322: WHERE event_offer_id LIKE p_e_c
323: OR UPPER(event_offer_name) LIKE p_e_c
324: -- SELECT code, name
325: -- FROM as_promotions_all

Line 389: FROM ams_event_offers_vl

385: CURSOR cur_promotion_code(p_e_c varchar2)
386: IS
387: -- RN 25/9/00
388: SELECT event_offer_id code, event_offer_name name
389: FROM ams_event_offers_vl
390: WHERE event_offer_id LIKE p_e_c
391: OR UPPER(event_offer_name) LIKE p_e_c
392: -- SELECT code, name
393: -- FROM as_promotions_all