APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 534: UPDATE ams_campaign_schedules_b

530: SET accounts_closed_flag = 'Y'
531: WHERE campaign_id = l_object_tbl (k).object_id;
532: -- Campaign Schdules
533: ELSIF p_object_type = 'CSCH' THEN
534: UPDATE ams_campaign_schedules_b
535: SET accounts_closed_flag = 'Y'
536: WHERE schedule_id = l_object_tbl (k).object_id;
537: -- Event Header/Rollup Event
538: ELSIF p_object_type = 'EVEH' THEN

Line 667: FROM ams_campaign_schedules_b sch,ams_campaigns_all_b camp

663: AND camp.campaign_id = offr.budget_source_id;
664:
665: CURSOR c_schedule_data(p_schedule_id IN NUMBER) IS
666: SELECT sch.campaign_id,NVL(source_from_parent,'N'),camp.transaction_currency_code
667: FROM ams_campaign_schedules_b sch,ams_campaigns_all_b camp
668: WHERE sch.schedule_id = p_schedule_id
669: AND camp.campaign_id = sch.campaign_id;
670:
671: CURSOR c_event_sch_data(pschedule_id IN NUMBER) IS