APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 161: FROM ams_campaigns_all_b ozf

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

Line 529: UPDATE ams_campaigns_all_b

525: END IF;
526:
527: IF l_return_status = fnd_api.g_ret_sts_success THEN
528: IF p_object_type = 'CAMP' THEN
529: UPDATE ams_campaigns_all_b
530: SET accounts_closed_flag = 'Y'
531: WHERE campaign_id = l_object_tbl (k).object_id;
532: -- Campaign Schdules
533: ELSIF p_object_type = 'CSCH' THEN

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

Line 661: FROM ozf_offers offr,ams_campaigns_all_b camp

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

Line 667: FROM ams_campaign_schedules_b sch,ams_campaigns_all_b camp

663: AND camp.campaign_id = offr.budget_source_id;
664:
665: CURSOR c_schedule_data(p_schedule_id IN NUMBER) IS
666: SELECT sch.campaign_id,NVL(source_from_parent,'N'),camp.transaction_currency_code
667: FROM ams_campaign_schedules_b sch,ams_campaigns_all_b camp
668: WHERE sch.schedule_id = p_schedule_id
669: AND camp.campaign_id = sch.campaign_id;
670:
671: CURSOR c_event_sch_data(pschedule_id IN NUMBER) IS