DBA Data[Home] [Help]

APPS.AMS_APPROVAL_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

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 3608: FROM ams_campaign_schedules_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
3608: FROM ams_campaign_schedules_vl
3609: WHERE schedule_id = p_object_id;
3610: CURSOR c_offer IS
3611: SELECT transaction_currency_code
3612: FROM ozf_offers OFF