APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 173: FROM ams_event_headers_all_b ozf

169: p_code IN VARCHAR2,
170: p_end_date IN DATE) IS
171: SELECT ozf.event_header_id object_id
172: ,ozf.currency_code_tc object_curr
173: FROM ams_event_headers_all_b ozf
174: WHERE NVL (ozf.active_to_date, p_grace_date) <= p_grace_date
175: -- changed to archived 08/20/2001 mpande
176: --AND ozf.system_status_code IN ('CLOSED','CANCELLED','ARCHIVED') -- inactive;
177: AND ozf.system_status_code IN (p_status)

Line 536: UPDATE ams_event_headers_all_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
536: UPDATE ams_event_headers_all_b
537: SET accounts_closed_flag = 'Y'
538: WHERE event_header_id = l_object_tbl (k).object_id;
539: -- Event Offer/Execution Event
540: ELSIF p_object_type = 'EVEO' OR p_object_type = 'EONE' THEN

Line 670: FROM ams_event_offers_all_b sch,ams_event_headers_all_b evt

666: AND camp.campaign_id = sch.campaign_id;
667:
668: CURSOR c_event_sch_data(pschedule_id IN NUMBER) IS
669: SELECT sch.event_header_id, NVL(sch.source_from_parent,'N'),evt.currency_code_tc
670: FROM ams_event_offers_all_b sch,ams_event_headers_all_b evt
671: WHERE sch.event_offer_id = pschedule_id
672: AND sch.event_header_id = evt.event_header_id;
673:
674: -- for sourcing from budgets.