APPS.AMS_APPROVAL_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 791: FROM ams_event_headers_vl A, ams_campaigns_vl b

787: ''priority_desc,
788: A.source_code,
789: b.source_code ,
790: b.campaign_name
791: FROM ams_event_headers_vl A, ams_campaigns_vl b
792: WHERE A.event_header_id = p_activity_id
793: AND NVL(A.program_id, 0) = b.campaign_id(+);
794: ELSIF p_activity_type = 'EVEO' THEN
795: OPEN l_obj_details FOR

Line 814: FROM ams_event_offers_vl A, ams_event_headers_vl b

810: ''priority_desc,
811: A.source_code,
812: b.source_code,
813: b.event_header_name
814: FROM ams_event_offers_vl A, ams_event_headers_vl b
815: WHERE A.event_offer_id = p_activity_id
816: AND A.event_object_type = 'EVEO'
817: AND A.event_header_id = b.event_header_id;
818: /* code added by murali start */

Line 3704: FROM ams_event_headers_vl

3700: WHERE OFF.qp_list_header_id = p_object_id;
3701: /* code added by murali code done by ravi end*/
3702: CURSOR c_eheader IS
3703: SELECT currency_code_tc
3704: FROM ams_event_headers_vl
3705: WHERE event_header_id = p_object_id;
3706: CURSOR c_eoffer IS
3707: SELECT currency_code_tc
3708: FROM ams_event_offers_vl