APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 193: FROM ams_event_offers_all_b ozf

189: p_end_date IN DATE) IS
190: SELECT ozf.event_offer_id object_id
191: ,ozf.currency_code_tc object_curr
192: --, ozf.event_end_date
193: FROM ams_event_offers_all_b ozf
194: WHERE NVL (ozf.event_end_date, p_grace_date) <= p_grace_date
195: -- changed to archived 08/20/2001 mpande
196: --AND ozf.system_status_code IN ('CLOSED','CANCELLED','ARCHIVED') -- inactive ;
197: AND ozf.system_status_code IN (p_status)

Line 211: FROM ams_event_offers_all_b ozf

207: p_end_date IN DATE) IS
208: SELECT ozf.event_offer_id object_id
209: ,ozf.currency_code_tc object_curr
210: --, ozf.event_end_date
211: FROM ams_event_offers_all_b ozf
212: WHERE NVL (ozf.event_end_date, p_grace_date) <= p_grace_date
213: -- changed to archived 08/20/2001 mpande
214: --AND ozf.system_status_code IN ('CLOSED','CANCELLED','ARCHIVED') -- inactive ;
215: AND ozf.system_status_code IN (p_status)

Line 544: UPDATE ams_event_offers_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
544: UPDATE ams_event_offers_all_b
545: SET accounts_closed_flag = 'Y'
546: WHERE event_offer_id = l_object_tbl (k).object_id;
547: -- Deliverable
548: ELSIF p_object_type = 'DELV' 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.