APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 531: UPDATE ams_campaign_schedules_b

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

Line 664: FROM ams_campaign_schedules_b sch,ams_campaigns_all_b camp

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