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 5026: ams_campaigns_all_b camp,

5022: parentCSCH.end_date_time,
5023: parentCSCH.status_code
5024: FROM ams_campaign_schedules_vl csch,
5025: ams_scheduler scheduler,
5026: ams_campaigns_all_b camp,
5027: ams_campaign_Schedules_b parentCSCH
5028: WHERE csch.schedule_id = p_schedule_id
5029: AND scheduler.OBJECT_ID = nvl(csch.orig_csch_id, csch.schedule_id)
5030: AND scheduler.OBJECT_TYPE = 'CSCH'

Line 6131: FROM AMS_CAMPAIGNS_ALL_B

6127:
6128: CURSOR l_camp_det (p_campaign_id NUMBER) IS
6129: SELECT
6130: actual_exec_end_date
6131: FROM AMS_CAMPAIGNS_ALL_B
6132: WHERE CAMPAIGN_ID = p_campaign_id;
6133:
6134:
6135: l_api_version CONSTANT NUMBER := 1.0 ;