APPS.AMS_APPROVAL_PVT dependencies on AMS_CAMPAIGNS_VL

Line 682: FROM ams_campaigns_vl A, ams_campaigns_vl b

678: ''priority_desc,
679: A.source_code,
680: b.source_code,
681: b.campaign_name
682: FROM ams_campaigns_vl A, ams_campaigns_vl b
683: WHERE A.campaign_id = p_activity_id
684: AND NVL(A.parent_campaign_id, 0) = b.campaign_id(+);
685: /* code added by murali and the code from ravi start*/
686: ELSIF p_activity_type = 'CSCH' THEN

Line 707: FROM ams_campaign_schedules_vl A, ams_campaigns_vl b

703: ''priority_desc,
704: A.source_code,
705: b.source_code ,
706: b.campaign_name
707: FROM ams_campaign_schedules_vl A, ams_campaigns_vl b
708: WHERE A.schedule_id=p_activity_id
709: AND b.campaign_id=A.campaign_id
710: AND NVL(A.campaign_id, 0) = b.campaign_id;
711: ELSIF p_activity_type = 'OFFR' THEN

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

3599: l_currency_code VARCHAR2(15);
3600:
3601: CURSOR c_campaign IS
3602: SELECT transaction_currency_code
3603: FROM ams_campaigns_vl
3604: WHERE campaign_id = p_object_id;
3605: /* code added by murali code done by ravi start*/
3606: CURSOR c_schedule IS
3607: SELECT transaction_currency_code