DBA Data[Home] [Help]

APPS.AMS_APPROVAL_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

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 3695: FROM ams_campaign_schedules_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
3695: FROM ams_campaign_schedules_vl
3696: WHERE schedule_id = p_object_id;
3697: CURSOR c_offer IS
3698: SELECT transaction_currency_code
3699: FROM ozf_offers OFF