APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 190: FROM ams_event_offers_all_b ozf

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

Line 208: FROM ams_event_offers_all_b ozf

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

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