APPS.IGC_VENDOR_MERGE_PVT dependencies on IGC_CC_HEADERS

Line 14: -- This API will update the igc_cc_headers table and the po_headers table

10: --
11: -- *************************************************************************
12: -- Procedure : Merge_Vendor
13: -- If CC is enabled,IGI_VENDOR_MERGE_GRP.merge_vendor will call this API.
14: -- This API will update the igc_cc_headers table and the po_headers table
15: -- It will update the PO headers table only for those records which are
16: -- CC related.
17: -- *************************************************************************
18:

Line 65: FROM igc_cc_headers

61: last_updated_by = FND_GLOBAL.user_id
62: WHERE vendor_id = p_old_vendor_id
63: AND vendor_site_id = p_old_vendor_site_id
64: AND segment1 IN (SELECT cc_num
65: FROM igc_cc_headers
66: WHERE org_id = g_org_id
67: AND vendor_id = p_old_vendor_id
68: AND vendor_site_id = p_old_vendor_site_id);
69:

Line 70: UPDATE igc_cc_headers

66: WHERE org_id = g_org_id
67: AND vendor_id = p_old_vendor_id
68: AND vendor_site_id = p_old_vendor_site_id);
69:
70: UPDATE igc_cc_headers
71: SET vendor_id = p_new_vendor_id,
72: vendor_site_id = p_new_vendor_site_id,
73: last_update_date = SYSDATE,
74: last_update_login = FND_GLOBAL.login_id,