APPS.HZ_PARTY_V2PUB dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 3575: SELECT 'Y' INTO l_temp FROM hz_party_usg_assignments WHERE party_id=p_party_id AND party_usage_code='SUPPLIER'

3571:
3572: BEGIN
3573: IF p_party_type = 'ORGANIZATION'
3574: AND p_organization_rec.organization_name <> p_old_organization_rec.organization_name THEN
3575: SELECT 'Y' INTO l_temp FROM hz_party_usg_assignments WHERE party_id=p_party_id AND party_usage_code='SUPPLIER'
3576: AND ROWNUM=1;
3577: IF l_temp ='Y' THEN
3578: ICX_CAT_POPULATE_ITEM_GRP.populateVendorNameChanges
3579: (

Line 9127: FROM hz_party_usg_assignments pu

9123: CURSOR c_supplier (
9124: p_party_id NUMBER
9125: ) IS
9126: SELECT null
9127: FROM hz_party_usg_assignments pu
9128: WHERE pu.party_id = p_party_id
9129: AND pu.party_usage_code = c_supplier_code
9130: AND ROWNUM = 1;
9131: