APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 3964: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';

3960: -- Fix for bug 1397577.
3961: l_table_name := 'AMS_DELIVERABLES_VL';
3962: l_pk_name := 'DELIVERABLE_ID';
3963: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CSCH' THEN
3964: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3965: l_pk_name := 'SCHEDULE_ID';
3966: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'FUND' THEN
3967: l_table_name := 'OZF_FUNDS_ALL_B';
3968: l_pk_name := 'FUND_ID';

Line 4009: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';

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';
4011: ELSIF p_act_budgets_rec.budget_source_type = 'SOFT_FUND' THEN
4012: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
4013: l_pk_name := 'REQUEST_HEADER_ID';

Line 5203: FROM ams_campaign_schedules_vl

5199: WHERE campaign_id = p_object_id;
5200:
5201: CURSOR c_campaign_schl IS
5202: SELECT transaction_currency_code
5203: FROM ams_campaign_schedules_vl
5204: WHERE schedule_id = p_object_id;
5205:
5206: CURSOR c_eheader IS
5207: SELECT currency_code_tc