APPS.AMS_WFTRIG_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 89: FROM ams_event_offers_vl

85: WHERE event_header_id = p_activity_id ;
86:
87: CURSOR c_eveo_det IS
88: SELECT owner_user_id
89: FROM ams_event_offers_vl
90: WHERE event_offer_id = p_activity_id ;
91:
92: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS
93: SELECT employee_id

Line 3393: FROM ams_event_offers_vl

3389: WHERE schedule_id = l_trig_rec.trigger_created_for_id ;
3390:
3391: CURSOR c_eveo_eone_det IS
3392: SELECT event_offer_name, 'STANDARD', owner_user_id
3393: FROM ams_event_offers_vl
3394: WHERE event_offer_id = l_trig_rec.trigger_created_for_id ;
3395:
3396: CURSOR c_eveh_det IS
3397: SELECT event_header_name, 'STANDARD', owner_user_id