APPS.AMS_APPROVAL_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 755: FROM ams_event_headers_vl A, ams_campaigns_vl b

751: ''priority_desc,
752: A.source_code,
753: b.source_code ,
754: b.campaign_name
755: FROM ams_event_headers_vl A, ams_campaigns_vl b
756: WHERE A.event_header_id = p_activity_id
757: AND NVL(A.program_id, 0) = b.campaign_id(+);
758: ELSIF p_activity_type = 'EVEO' THEN
759: OPEN l_obj_details FOR

Line 778: FROM ams_event_offers_vl A, ams_event_headers_vl b

774: ''priority_desc,
775: A.source_code,
776: b.source_code,
777: b.event_header_name
778: FROM ams_event_offers_vl A, ams_event_headers_vl b
779: WHERE A.event_offer_id = p_activity_id
780: AND A.event_object_type = 'EVEO'
781: AND A.event_header_id = b.event_header_id;
782: /* code added by murali start */

Line 3617: FROM ams_event_headers_vl

3613: WHERE OFF.qp_list_header_id = p_object_id;
3614: /* code added by murali code done by ravi end*/
3615: CURSOR c_eheader IS
3616: SELECT currency_code_tc
3617: FROM ams_event_headers_vl
3618: WHERE event_header_id = p_object_id;
3619: CURSOR c_eoffer IS
3620: SELECT currency_code_tc
3621: FROM ams_event_offers_vl