DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 3939: l_table_name := 'AMS_EVENT_HEADERS_VL';

3935: --
3936: -- Check FK parameter: act_budget_used_by_id #1
3937: IF p_act_budgets_rec.act_budget_used_by_id <> fnd_api.g_miss_num THEN
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';

Line 4000: l_table_name := 'AMS_EVENT_HEADERS_VL';

3996: -- Partner funds will not have a budget source ID
3997: IF p_act_budgets_rec.budget_source_id <> fnd_api.g_miss_num
3998: AND p_act_budgets_rec.budget_source_id IS NOT NULL THEN
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';

Line 5208: FROM ams_event_headers_vl

5204: WHERE schedule_id = p_object_id;
5205:
5206: CURSOR c_eheader IS
5207: SELECT currency_code_tc
5208: FROM ams_event_headers_vl
5209: WHERE event_header_id = p_object_id;
5210:
5211: CURSOR c_eoffer IS
5212: SELECT currency_code_tc