APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_CAMPAIGNS_VL

Line 3128: l_table_name := 'AMS_CAMPAIGNS_VL';

3124: ELSIF p_act_budgets_rec.arc_act_budget_used_by IN ( 'EVEO','EONE') THEN
3125: l_table_name := 'AMS_EVENT_OFFERS_VL';
3126: l_pk_name := 'EVENT_OFFER_ID';
3127: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CAMP' THEN
3128: l_table_name := 'AMS_CAMPAIGNS_VL';
3129: l_pk_name := 'CAMPAIGN_ID';
3130: -- 02/23/2001 mpande ADDED for Hornet reqmt
3131: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'OFFR'
3132: OR p_act_budgets_rec.arc_act_budget_used_by = 'PRIC' THEN -- yzhao: 10/20/2003 added for price list

Line 3189: l_table_name := 'AMS_CAMPAIGNS_VL';

3185: ELSIF p_act_budgets_rec.budget_source_type IN ('EONE', 'EVEO') THEN
3186: l_table_name := 'AMS_EVENT_OFFERS_VL';
3187: l_pk_name := 'EVENT_OFFER_ID';
3188: ELSIF p_act_budgets_rec.budget_source_type = 'CAMP' THEN
3189: l_table_name := 'AMS_CAMPAIGNS_VL';
3190: l_pk_name := 'CAMPAIGN_ID';
3191: ELSIF p_act_budgets_rec.budget_source_type = 'CSCH' THEN
3192: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3193: l_pk_name := 'SCHEDULE_ID';

Line 4381: FROM ams_campaigns_vl

4377: l_currency_code VARCHAR2 (15);
4378:
4379: CURSOR c_campaign IS
4380: SELECT transaction_currency_code
4381: FROM ams_campaigns_vl
4382: WHERE campaign_id = p_object_id;
4383:
4384: CURSOR c_campaign_schl IS
4385: SELECT transaction_currency_code