306: AND VENDOR_TYPE_LOOKUP_CODE is not null
307: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
308:
309: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
310: l_status fnd_module_installations.status%TYPE;
311: l_db_status fnd_module_installations.DB_STATUS%TYPE;
312:
313: BEGIN
314:
307: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
308:
309: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
310: l_status fnd_module_installations.status%TYPE;
311: l_db_status fnd_module_installations.DB_STATUS%TYPE;
312:
313: BEGIN
314:
315: IF P_DML_TYPE = 'I' THEN