APPS.AP_VENDOR_PUB_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 2693: FROM HZ_PARTY_USG_ASSIGNMENTS HPUA

2689: IF x_valid = TRUE THEN
2690: --check usage status
2691: SELECT count(party_id)
2692: INTO l_count
2693: FROM HZ_PARTY_USG_ASSIGNMENTS HPUA
2694: WHERE HPUA.PARTY_USAGE_CODE in
2695: ('SUPPLIER','SUPPLIER_CONTACT', 'ORG_CONTACT')
2696: AND HPUA.PARTY_ID = p_party_id;
2697: