APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_CAMPAIGNS_VL

Line 3945: l_table_name := 'AMS_CAMPAIGNS_VL';

3941: ELSIF p_act_budgets_rec.arc_act_budget_used_by IN ( 'EVEO','EONE') THEN
3942: l_table_name := 'AMS_EVENT_OFFERS_VL';
3943: l_pk_name := 'EVENT_OFFER_ID';
3944: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CAMP' THEN
3945: l_table_name := 'AMS_CAMPAIGNS_VL';
3946: l_pk_name := 'CAMPAIGN_ID';
3947: -- 02/23/2001 mpande ADDED for Hornet reqmt
3948: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'OFFR'
3949: OR p_act_budgets_rec.arc_act_budget_used_by = 'PRIC' THEN -- yzhao: 10/20/2003 added for price list

Line 4006: l_table_name := 'AMS_CAMPAIGNS_VL';

4002: ELSIF p_act_budgets_rec.budget_source_type IN ('EONE', 'EVEO') THEN
4003: l_table_name := 'AMS_EVENT_OFFERS_VL';
4004: l_pk_name := 'EVENT_OFFER_ID';
4005: ELSIF p_act_budgets_rec.budget_source_type = 'CAMP' THEN
4006: l_table_name := 'AMS_CAMPAIGNS_VL';
4007: l_pk_name := 'CAMPAIGN_ID';
4008: ELSIF p_act_budgets_rec.budget_source_type = 'CSCH' THEN
4009: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
4010: l_pk_name := 'SCHEDULE_ID';

Line 5198: FROM ams_campaigns_vl

5194: l_currency_code VARCHAR2 (15);
5195:
5196: CURSOR c_campaign IS
5197: SELECT transaction_currency_code
5198: FROM ams_campaigns_vl
5199: WHERE campaign_id = p_object_id;
5200:
5201: CURSOR c_campaign_schl IS
5202: SELECT transaction_currency_code