APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 3147: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';

3143: -- Fix for bug 1397577.
3144: l_table_name := 'AMS_DELIVERABLES_VL';
3145: l_pk_name := 'DELIVERABLE_ID';
3146: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CSCH' THEN
3147: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3148: l_pk_name := 'SCHEDULE_ID';
3149: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'FUND' THEN
3150: l_table_name := 'OZF_FUNDS_ALL_B';
3151: l_pk_name := 'FUND_ID';

Line 3192: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';

3188: ELSIF p_act_budgets_rec.budget_source_type = 'CAMP' THEN
3189: l_table_name := 'AMS_CAMPAIGNS_VL';
3190: l_pk_name := 'CAMPAIGN_ID';
3191: ELSIF p_act_budgets_rec.budget_source_type = 'CSCH' THEN
3192: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3193: l_pk_name := 'SCHEDULE_ID';
3194: ELSIF p_act_budgets_rec.budget_source_type = 'SOFT_FUND' THEN
3195: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3196: l_pk_name := 'REQUEST_HEADER_ID';

Line 4386: FROM ams_campaign_schedules_vl

4382: WHERE campaign_id = p_object_id;
4383:
4384: CURSOR c_campaign_schl IS
4385: SELECT transaction_currency_code
4386: FROM ams_campaign_schedules_vl
4387: WHERE schedule_id = p_object_id;
4388:
4389: CURSOR c_eheader IS
4390: SELECT currency_code_tc