APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 3942: l_table_name := 'AMS_EVENT_OFFERS_VL';

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

Line 4003: l_table_name := 'AMS_EVENT_OFFERS_VL';

3999: IF p_act_budgets_rec.budget_source_type = 'EVEH' THEN
4000: l_table_name := 'AMS_EVENT_HEADERS_VL';
4001: l_pk_name := 'EVENT_HEADER_ID';
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';

Line 5213: FROM ams_event_offers_vl

5209: WHERE event_header_id = p_object_id;
5210:
5211: CURSOR c_eoffer IS
5212: SELECT currency_code_tc
5213: FROM ams_event_offers_vl
5214: WHERE event_offer_id = p_object_id;
5215:
5216: CURSOR c_deliverable IS
5217: SELECT transaction_currency_code