DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 3122: l_table_name := 'AMS_EVENT_HEADERS_VL';

3118: --
3119: -- Check FK parameter: act_budget_used_by_id #1
3120: IF p_act_budgets_rec.act_budget_used_by_id <> fnd_api.g_miss_num THEN
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';

Line 3183: l_table_name := 'AMS_EVENT_HEADERS_VL';

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

Line 4391: FROM ams_event_headers_vl

4387: WHERE schedule_id = p_object_id;
4388:
4389: CURSOR c_eheader IS
4390: SELECT currency_code_tc
4391: FROM ams_event_headers_vl
4392: WHERE event_header_id = p_object_id;
4393:
4394: CURSOR c_eoffer IS
4395: SELECT currency_code_tc