APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 1152: FROM ams_campaigns_all_b

1148:
1149: CURSOR c_campaign IS
1150: SELECT actual_exec_start_date,
1151: actual_exec_end_date
1152: FROM ams_campaigns_all_b
1153: WHERE campaign_id = p_campaign_id;
1154:
1155: l_parent_start_date DATE;
1156: l_parent_end_date DATE;

Line 1984: FROM ams_campaigns_all_b

1980: AND act_budget_used_by_id = p_schedule_id);
1981:
1982: CURSOR c_camp_status IS
1983: SELECT status_code
1984: FROM ams_campaigns_all_b
1985: WHERE campaign_id = p_campaign_id ;
1986:
1987: -- soagrawa added the following cursor on 30-sep-2003 for stamping version in 11.5.10
1988: CURSOR c_cover_letter_det IS

Line 5056: ams_campaigns_all_b camp,

5052: parentCSCH.end_date_time,
5053: parentCSCH.status_code
5054: FROM ams_campaign_schedules_vl csch,
5055: ams_scheduler scheduler,
5056: ams_campaigns_all_b camp,
5057: ams_campaign_Schedules_b parentCSCH
5058: WHERE csch.schedule_id = p_schedule_id
5059: AND scheduler.OBJECT_ID = nvl(csch.orig_csch_id, csch.schedule_id)
5060: AND scheduler.OBJECT_TYPE = 'CSCH'

Line 6161: FROM AMS_CAMPAIGNS_ALL_B

6157:
6158: CURSOR l_camp_det (p_campaign_id NUMBER) IS
6159: SELECT
6160: actual_exec_end_date
6161: FROM AMS_CAMPAIGNS_ALL_B
6162: WHERE CAMPAIGN_ID = p_campaign_id;
6163:
6164:
6165: l_api_version CONSTANT NUMBER := 1.0 ;