APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 158: FROM ams_campaigns_all_b ozf

154: p_end_date IN DATE) IS
155: SELECT ozf.campaign_id object_id
156: ,ozf.transaction_currency_code object_curr
157: --, ozf.actual_execution_end_date
158: FROM ams_campaigns_all_b ozf
159: WHERE NVL (ozf.actual_exec_end_date, p_grace_date) <= p_grace_date
160: -- changed to archived 08/20/2001 mpande
161: --AND ozf.status_code IN ('CLOSED','COMPLETED','CANCELLED','ARCHIVED') -- inactive camps;
162: AND ozf.status_code IN (p_status)

Line 526: UPDATE ams_campaigns_all_b

522: END IF;
523:
524: IF l_return_status = fnd_api.g_ret_sts_success THEN
525: IF p_object_type = 'CAMP' THEN
526: UPDATE ams_campaigns_all_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

Line 546: UPDATE ams_campaigns_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
546: UPDATE ams_campaigns_all_b
547: SET accounts_closed_flag = 'Y'
548: WHERE campaign_id = l_object_tbl (k).object_id;
549: -- we do not need to check this for fund
550: ELSIF p_object_type = 'OFFR' THEN

Line 658: FROM ozf_offers offr,ams_campaigns_all_b camp

654:
655: -- used to get parent_id, parent currency, and source from parent flag.
656: CURSOR c_offer_data(p_offer_id IN NUMBER) IS
657: SELECT offr.budget_source_id,NVL(offr.source_from_parent,'N'),camp.transaction_currency_code
658: FROM ozf_offers offr,ams_campaigns_all_b camp
659: WHERE offr.qp_list_header_id = p_offer_id
660: AND camp.campaign_id = offr.budget_source_id;
661:
662: CURSOR c_schedule_data(p_schedule_id IN NUMBER) IS

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