APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 151: FROM ams_campaigns_all_b

147:
148: --check for the parent campaign
149: CURSOR c_check_parent_campaign(l_act_metric_used_by_id NUMBER) IS
150: SELECT parent_campaign_id
151: FROM ams_campaigns_all_b
152: WHERE campaign_id = l_act_metric_used_by_id;
153:
154: --check for the parent event
155: CURSOR c_check_parent_event(l_act_metric_used_by_id NUMBER) IS

Line 184: FROM ams_campaigns_all_b

180: WHERE event_header_id = l_act_metric_used_by_id;
181:
182: CURSOR c_check_camp_type (l_camp_id NUMBER) IS
183: SELECT rollup_type
184: FROM ams_campaigns_all_b
185: WHERE campaign_id = l_camp_id;
186:
187: -- 06/23/2001 huili added
188: --check the parent campaign for schedule

Line 1217: FROM ams_campaigns_all_b

1213: )
1214: IS
1215: CURSOR c_camp(id NUMBER) IS
1216: SELECT Fnd_Api.G_TRUE
1217: FROM ams_campaigns_all_b
1218: WHERE campaign_id = id
1219: AND status_code = 'CANCELLED';
1220:
1221: CURSOR c_csch(id NUMBER) IS

Line 2519: FROM ams_campaigns_all_b

2515: l_accrual_type VARCHAR2(2000);
2516:
2517: CURSOR c_get_camp_setup(p_campaign_id NUMBER) IS
2518: SELECT custom_setup_id
2519: FROM ams_campaigns_all_b
2520: WHERE campaign_id = p_campaign_id;
2521:
2522: CURSOR c_get_csch_setup(p_schedule_id NUMBER) IS
2523: SELECT custom_setup_id