APPS.AP_PURGE_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 6590: FROM ap_supplier_contacts pc

6586:
6587:
6588: /* Added for bug#9645593 Start */
6589: DELETE
6590: FROM ap_supplier_contacts pc
6591: WHERE pc.org_party_site_id IN
6592: ( SELECT vnd.party_site_id
6593: FROM ap_supplier_sites_all vnd
6594: , po_purge_vendor_list pvl

Line 6608: debug_info := 'ap_supplier_contacts';

6604: from po_purge_vendor_list pvl
6605: where pvl.vendor_id = vnd.vendor_id
6606: and pvl.double_check_flag = 'Y');
6607:
6608: debug_info := 'ap_supplier_contacts';
6609: IF g_debug_switch in ('y','Y') THEN
6610: Print('(Purge_Vendors)'||debug_info);
6611: END IF;
6612:

Line 6615: -- delete_ap_supplier_contacts

6611: END IF;
6612:
6613: /* Commented for bug#9645593 Start
6614: Moved the below code before deleting the supplier site
6615: -- delete_ap_supplier_contacts
6616: delete from ap_supplier_contacts pc
6617: where not exists
6618: (select null
6619: from ap_supplier_sites_all ps

Line 6616: delete from ap_supplier_contacts pc

6612:
6613: /* Commented for bug#9645593 Start
6614: Moved the below code before deleting the supplier site
6615: -- delete_ap_supplier_contacts
6616: delete from ap_supplier_contacts pc
6617: where not exists
6618: (select null
6619: from ap_supplier_sites_all ps
6620: where ps.vendor_site_id = pc.vendor_site_id);