APPS.AMS_APPROVAL_PVT dependencies on AMS_CAMPAIGNS_VL

Line 717: FROM ams_campaigns_vl A, ams_campaigns_vl b

713: ''priority_desc,
714: A.source_code,
715: b.source_code,
716: b.campaign_name
717: FROM ams_campaigns_vl A, ams_campaigns_vl b
718: WHERE A.campaign_id = p_activity_id
719: AND NVL(A.parent_campaign_id, 0) = b.campaign_id(+);
720: /* code added by murali and the code from ravi start*/
721: ELSIF p_activity_type = 'CSCH' THEN

Line 742: FROM ams_campaign_schedules_vl A, ams_campaigns_vl b

738: ''priority_desc,
739: A.source_code,
740: b.source_code ,
741: b.campaign_name
742: FROM ams_campaign_schedules_vl A, ams_campaigns_vl b
743: WHERE A.schedule_id=p_activity_id
744: AND b.campaign_id=A.campaign_id
745: AND NVL(A.campaign_id, 0) = b.campaign_id;
746: ELSIF p_activity_type = 'OFFR' THEN

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 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 3690: FROM ams_campaigns_vl

3686: l_currency_code VARCHAR2(15);
3687:
3688: CURSOR c_campaign IS
3689: SELECT transaction_currency_code
3690: FROM ams_campaigns_vl
3691: WHERE campaign_id = p_object_id;
3692: /* code added by murali code done by ravi start*/
3693: CURSOR c_schedule IS
3694: SELECT transaction_currency_code