APPS.AP_VENDOR_PUB_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 2382: FROM HZ_PARTY_USG_ASSIGNMENTS HPUA

2378: IF x_valid = TRUE THEN
2379: --check usage status
2380: SELECT count(party_id)
2381: INTO l_count
2382: FROM HZ_PARTY_USG_ASSIGNMENTS HPUA
2383: WHERE HPUA.PARTY_USAGE_CODE in
2384: ('SUPPLIER','SUPPLIER_CONTACT', 'ORG_CONTACT')
2385: AND HPUA.PARTY_ID = p_party_id;
2386: