APPS.OZF_UTILITY_PVT dependencies on AMS_CAMPAIGN_SCHEDULES

Line 720: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';

716: x_return_status := FND_API.G_RET_STS_SUCCESS;
717:
718: IF (p_sys_qual ='CSCH') THEN
719: -- Start of code modified by ptendulk on 30-Jan-2001
720: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';
721: --x_pk_name := 'CAMPAIGN_SCHEDULE_ID';
722: -- End of code modified by ptendulk on 30-Jan-2001
723: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
724: x_pk_name := 'SCHEDULE_ID';

Line 723: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';

719: -- Start of code modified by ptendulk on 30-Jan-2001
720: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';
721: --x_pk_name := 'CAMPAIGN_SCHEDULE_ID';
722: -- End of code modified by ptendulk on 30-Jan-2001
723: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
724: x_pk_name := 'SCHEDULE_ID';
725: ELSIF (p_sys_qual ='CAMP') THEN
726: -- Start of code modified by ptendulk on 30-Jan-2001
727: --x_table_name := 'AMS_CAMPAIGNS_VL';

Line 878: ams_campaign_schedules s

874: --added 11/16/99 tdonohoe
875: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS
876: SELECT c.campaign_name
877: FROM ams_campaigns_vl c,
878: ams_campaign_schedules s
879: WHERE s.campaign_schedule_id = p_object_id
880: AND s.campaign_id = c.campaign_id;
881:
882: CURSOR c_deliv(p_object_id IN NUMBER) IS