APPS.AMS_WFCMPAPR_PVT dependencies on AMS_EVENT_OFFERS_VL

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 604: FROM ams_event_offers_vl

600:
601: CURSOR c_eveo_det IS
602: SELECT fund_source_type_code,
603: fund_source_id
604: FROM ams_event_offers_vl
605: WHERE event_offer_id = p_activity_id ;
606:
607:
608: BEGIN

Line 679: FROM ams_event_offers_vl

675: WHERE event_header_id = l_source_id ;
676:
677: CURSOR c_eveo_det IS
678: SELECT owner_user_id
679: FROM ams_event_offers_vl
680: WHERE event_offer_id = l_source_id ;
681:
682: -- Following Code is Added by ptendulk on 28th Jan
683: -- Get the person ID from JTF

Line 3050: FROM ams_jtf_rs_emp_v jtf,ams_event_offers_vl eveo

3046:
3047: CURSOR c_eveo_owner(l_id NUMBER)
3048: IS
3049: SELECT jtf.full_name
3050: FROM ams_jtf_rs_emp_v jtf,ams_event_offers_vl eveo
3051: WHERE eveo.event_offer_id = l_id
3052: AND jtf.resource_id = eveo.owner_user_id ;
3053:
3054:

Line 3536: FROM ams_event_offers_vl o

3532: o.event_end_date,
3533: o.description,
3534: o.fund_amount_tc
3535: ,o.currency_code_tc
3536: FROM ams_event_offers_vl o
3537: WHERE o.event_offer_id = l_my_event_offer_id ;
3538:
3539:
3540: