APPS.AP_PURGE_PKG dependencies on AP_SUPPLIERS

Line 1485: from ap_suppliers vnd

1481: double_check_flag)
1482: select vnd.vendor_id,
1483: p_purge_name,
1484: 'Y'
1485: from ap_suppliers vnd
1486: where vnd.end_date_active <= g_activity_date
1487: and not exists (select 'vnd.vendor is a parent of
1488: another vendor'
1489: from ap_suppliers v

Line 1489: from ap_suppliers v

1485: from ap_suppliers vnd
1486: where vnd.end_date_active <= g_activity_date
1487: and not exists (select 'vnd.vendor is a parent of
1488: another vendor'
1489: from ap_suppliers v
1490: where v.parent_vendor_id =
1491: vnd.vendor_id)
1492: --Bug 2653578
1493: and PO_THIRD_PARTY_STOCK_GRP.validate_supplier_purge(

Line 2291: ap_suppliers vnd

2287: vnd.segment1,
2288: vnd.vendor_type_lookup_code,
2289: p_purge_name
2290: from po_purge_vendor_list pvl,
2291: ap_suppliers vnd
2292: where pvl.vendor_id = vnd.vendor_id
2293: and pvl.double_check_flag = 'Y';
2294:
2295: COMMIT;

Line 3439: from ap_suppliers vnd

3435: update po_purge_vendor_list pvl
3436: set double_check_flag = 'N'
3437: where pvl.double_check_flag = 'Y'
3438: and not exists (select null
3439: from ap_suppliers vnd
3440: where vnd.vendor_id = pvl.vendor_id
3441: --and nvl(vnd.vendor_type_lookup_code, 'VENDOR') <> 'EMPLOYEE'
3442: and nvl(vnd.end_date_active,sysdate) <=
3443: g_activity_date);

Line 5986: debug_info := 'ap_suppliers';

5982: current_calling_sequence := 'Purge_Vendors<-'||P_Calling_Sequence;
5983:
5984: --
5985:
5986: debug_info := 'ap_suppliers';
5987: IF g_debug_switch in ('y','Y') THEN
5988: Print('(Purge_Vendors)'||debug_info);
5989: END IF;
5990:

Line 5991: -- delete_ap_suppliers

5987: IF g_debug_switch in ('y','Y') THEN
5988: Print('(Purge_Vendors)'||debug_info);
5989: END IF;
5990:
5991: -- delete_ap_suppliers
5992: delete from ap_suppliers vnd
5993: where exists
5994: (select null
5995: from po_purge_vendor_list pvl

Line 5992: delete from ap_suppliers vnd

5988: Print('(Purge_Vendors)'||debug_info);
5989: END IF;
5990:
5991: -- delete_ap_suppliers
5992: delete from ap_suppliers vnd
5993: where exists
5994: (select null
5995: from po_purge_vendor_list pvl
5996: where pvl.vendor_id = vnd.vendor_id

Line 6073: from ap_suppliers vnd

6069:
6070: delete from po_vendor_list_entries pvle
6071: where not exists
6072: (select null
6073: from ap_suppliers vnd
6074: where vnd.vendor_id = pvle.vendor_id);
6075:
6076: debug_info := 'po_vendor_list_headers';
6077: IF g_debug_switch in ('y','Y') THEN