APPS.AMS_ASSOCIATIONS_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 1187: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';

1183: ELSIF p_master_type = 'EONE'
1184: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1185: l_foreign_table_id := 'EVENT_OFFER_ID';
1186: ELSIF p_master_type = 'CAMP'
1187: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';
1188: l_foreign_table_id := 'CAMPAIGN_ID';
1189: ELSIF p_master_type = 'CSCH'
1190: THEN l_foreign_table := 'AMS_CAMPAIGN_SCHEDULES_B';
1191: l_foreign_table_id := 'SCHEDULE_ID';

Line 1225: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';

1221: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1222: l_foreign_table_id := 'EVENT_OFFER_ID';
1223:
1224: ELSIF p_using_type = 'CAMP'
1225: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';
1226: l_foreign_table_id := 'CAMPAIGN_ID';
1227: ELSIF p_using_type = 'DELV'
1228: THEN l_foreign_table := 'AMS_DELIVERABLES_ALL_B';
1229: l_foreign_table_id := 'DELIVERABLE_ID';

Line 1638: FROM ams_campaigns_all_b

1634:
1635: CURSOR c_camp_end_date(l_camp_id IN NUMBER)
1636: IS
1637: SELECT actual_exec_end_date
1638: FROM ams_campaigns_all_b
1639: WHERE campaign_id = l_camp_id;
1640:
1641: CURSOR c_csch_end_date(l_camp_sche_id IN NUMBER)
1642: IS