5581: --Start of code changes for the bug 16244229
5582: WHERE NOT EXISTS ( SELECT 'Y'
5583: FROM
5584: AP_SUPPLIER_CONTACTS PVC ,
5585: AP_SUPPLIER_SITES_ALL PVS ,
5586: HZ_PARTIES HP ,
5587: HZ_RELATIONSHIPS HPR ,
5588: HZ_PARTY_SITES HPS ,
5589: HZ_ORG_CONTACTS HOC ,
7874: --Start of code changes for the bug 16244229
7875: WHERE NOT EXISTS ( SELECT 'Y'
7876: FROM
7877: AP_SUPPLIER_CONTACTS PVC ,
7878: AP_SUPPLIER_SITES_ALL PVS ,
7879: HZ_PARTIES HP ,
7880: HZ_RELATIONSHIPS HPR ,
7881: HZ_PARTY_SITES HPS ,
7882: HZ_ORG_CONTACTS HOC ,