DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 6035: debug_info := 'ap_supplier_contacts';

6031: from po_purge_vendor_list pvl
6032: where pvl.vendor_id = vnd.vendor_id
6033: and pvl.double_check_flag = 'Y');
6034:
6035: debug_info := 'ap_supplier_contacts';
6036: IF g_debug_switch in ('y','Y') THEN
6037: Print('(Purge_Vendors)'||debug_info);
6038: END IF;
6039:

Line 6040: -- delete_ap_supplier_contacts

6036: IF g_debug_switch in ('y','Y') THEN
6037: Print('(Purge_Vendors)'||debug_info);
6038: END IF;
6039:
6040: -- delete_ap_supplier_contacts
6041: delete from ap_supplier_contacts pc
6042: where not exists
6043: (select null
6044: from ap_supplier_sites_all ps

Line 6041: delete from ap_supplier_contacts pc

6037: Print('(Purge_Vendors)'||debug_info);
6038: END IF;
6039:
6040: -- delete_ap_supplier_contacts
6041: delete from ap_supplier_contacts pc
6042: where not exists
6043: (select null
6044: from ap_supplier_sites_all ps
6045: where ps.vendor_site_id = pc.vendor_site_id);