APPS.AMS_APPROVAL_PVT dependencies on AMS_EVENT_OFFERS_VL

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

799: '' priority_desc,
800: A.source_code,
801: b.source_code,
802: b.campaign_name
803: FROM ams_event_offers_vl A, ams_campaigns_vl b
804: WHERE A.event_offer_id = p_activity_id
805: AND A.event_object_type = 'EONE'
806: AND NVL(A.parent_id, 0) = b.campaign_id(+);
807: /* code added by murali start */

Line 3621: FROM ams_event_offers_vl

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
3622: WHERE event_offer_id = p_object_id;
3623: CURSOR c_deliverable IS
3624: SELECT transaction_currency_code
3625: FROM ams_deliverables_vl