APPS.AMS_APPROVAL_PVT dependencies on AMS_EVENT_OFFERS_VL

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 839: FROM ams_event_offers_vl A, ams_campaigns_vl b

835: '' priority_desc,
836: A.source_code,
837: b.source_code,
838: b.campaign_name
839: FROM ams_event_offers_vl A, ams_campaigns_vl b
840: WHERE A.event_offer_id = p_activity_id
841: AND A.event_object_type = 'EONE'
842: AND NVL(A.parent_id, 0) = b.campaign_id(+);
843: /* code added by murali start */

Line 3708: FROM ams_event_offers_vl

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
3709: WHERE event_offer_id = p_object_id;
3710: CURSOR c_deliverable IS
3711: SELECT transaction_currency_code
3712: FROM ams_deliverables_vl