APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 3125: l_table_name := 'AMS_EVENT_OFFERS_VL';

3121: IF p_act_budgets_rec.arc_act_budget_used_by = ('EVEH') THEN
3122: l_table_name := 'AMS_EVENT_HEADERS_VL';
3123: l_pk_name := 'EVENT_HEADER_ID';
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';

Line 3186: l_table_name := 'AMS_EVENT_OFFERS_VL';

3182: IF p_act_budgets_rec.budget_source_type = 'EVEH' THEN
3183: l_table_name := 'AMS_EVENT_HEADERS_VL';
3184: l_pk_name := 'EVENT_HEADER_ID';
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';

Line 4396: FROM ams_event_offers_vl

4392: WHERE event_header_id = p_object_id;
4393:
4394: CURSOR c_eoffer IS
4395: SELECT currency_code_tc
4396: FROM ams_event_offers_vl
4397: WHERE event_offer_id = p_object_id;
4398:
4399: CURSOR c_deliverable IS
4400: SELECT transaction_currency_code