APPS.OZF_UTILITY_PVT dependencies on AMS_CAMPAIGN_SCHEDULES

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

699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: IF (p_sys_qual ='CSCH') THEN
702: -- Start of code modified by ptendulk on 30-Jan-2001
703: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';
704: --x_pk_name := 'CAMPAIGN_SCHEDULE_ID';
705: -- End of code modified by ptendulk on 30-Jan-2001
706: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
707: x_pk_name := 'SCHEDULE_ID';

Line 706: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';

702: -- Start of code modified by ptendulk on 30-Jan-2001
703: --x_table_name := 'AMS_CAMPAIGN_SCHEDULES';
704: --x_pk_name := 'CAMPAIGN_SCHEDULE_ID';
705: -- End of code modified by ptendulk on 30-Jan-2001
706: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
707: x_pk_name := 'SCHEDULE_ID';
708: ELSIF (p_sys_qual ='CAMP') THEN
709: -- Start of code modified by ptendulk on 30-Jan-2001
710: --x_table_name := 'AMS_CAMPAIGNS_VL';

Line 861: ams_campaign_schedules s

857: --added 11/16/99 tdonohoe
858: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS
859: SELECT c.campaign_name
860: FROM ams_campaigns_vl c,
861: ams_campaign_schedules s
862: WHERE s.campaign_schedule_id = p_object_id
863: AND s.campaign_id = c.campaign_id;
864:
865: CURSOR c_deliv(p_object_id IN NUMBER) IS