APPS.AMS_WFCMPAPR_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 406: FROM ams_event_headers_vl

402: WHERE deliverable_id = p_activity_id ;
403:
404: CURSOR c_eveh_det IS
405: SELECT owner_user_id
406: FROM ams_event_headers_vl
407: WHERE event_header_id = p_activity_id ;
408:
409: -- Changed By ptendulk on 28 Jan 2000, The Owner
410: -- of the Event Offer will be the Owner of the Event

Line 415: FROM ams_event_offers_vl o,ams_event_headers_vl e

411: -- Header of that Campaign
412:
413: CURSOR c_eveo_det IS
414: SELECT e.owner_user_id
415: FROM ams_event_offers_vl o,ams_event_headers_vl e
416: WHERE o.event_offer_id = p_activity_id
417: AND o.event_header_id = e.event_header_id ;
418:
419: -- Following Code is Added by ptendulk on 28th Jan

Line 598: FROM ams_event_headers_vl

594:
595: CURSOR c_eveh_det IS
596: SELECT fund_source_type_code,
597: fund_source_id
598: FROM ams_event_headers_vl
599: WHERE event_header_id = p_activity_id ;
600:
601: CURSOR c_eveo_det IS
602: SELECT fund_source_type_code,

Line 674: FROM ams_event_headers_vl

670: WHERE deliverable_id = l_source_id ;
671:
672: CURSOR c_eveh_det IS
673: SELECT owner_user_id
674: FROM ams_event_headers_vl
675: WHERE event_header_id = l_source_id ;
676:
677: CURSOR c_eveo_det IS
678: SELECT owner_user_id

Line 2914: FROM ams_event_headers_vl

2910:
2911: CURSOR c_eveh_priority
2912: IS
2913: SELECT priority_type_code priority
2914: FROM ams_event_headers_vl
2915: WHERE event_header_id = p_obj_id ;
2916:
2917: CURSOR c_eveo_priority
2918: IS

Line 2920: FROM ams_event_headers_vl

2916:
2917: CURSOR c_eveo_priority
2918: IS
2919: SELECT priority_type_code priority
2920: FROM ams_event_headers_vl
2921: WHERE event_header_id = p_obj_id ;
2922:
2923: l_priority VARCHAR2(30);
2924: l_timeout_rec c_timeout%ROWTYPE;

Line 3043: FROM ams_jtf_rs_emp_v jtf,ams_event_headers_vl eveh

3039:
3040: CURSOR c_eveh_owner(l_id NUMBER)
3041: IS
3042: SELECT jtf.full_name
3043: FROM ams_jtf_rs_emp_v jtf,ams_event_headers_vl eveh
3044: WHERE eveh.event_header_id = l_id
3045: AND jtf.resource_id = eveh.owner_user_id ;
3046:
3047: CURSOR c_eveo_owner(l_id NUMBER)

Line 3523: FROM ams_event_headers_vl

3519: active_to_date,
3520: description,
3521: fund_amount_tc
3522: ,currency_code_tc
3523: FROM ams_event_headers_vl
3524: WHERE event_header_id = l_my_event_header_id ;
3525:
3526: l_eve_mkt_msg VARCHAR2(4000);
3527: