APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 176: FROM ams_event_headers_all_b ozf

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

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

Line 673: FROM ams_event_offers_all_b sch,ams_event_headers_all_b evt

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