APPS.HZ_PARTY_V2PUB dependencies on HZ_PARTY_USG_ASSIGNMENTS

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

3520:
3521: BEGIN
3522: IF p_party_type = 'ORGANIZATION'
3523: AND p_organization_rec.organization_name <> p_old_organization_rec.organization_name THEN
3524: SELECT 'Y' INTO l_temp FROM hz_party_usg_assignments WHERE party_id=p_party_id AND party_usage_code='SUPPLIER'
3525: AND ROWNUM=1;
3526: IF l_temp ='Y' THEN
3527: ICX_CAT_POPULATE_ITEM_GRP.populateVendorNameChanges
3528: (

Line 9015: FROM hz_party_usg_assignments pu

9011: CURSOR c_supplier (
9012: p_party_id NUMBER
9013: ) IS
9014: SELECT null
9015: FROM hz_party_usg_assignments pu
9016: WHERE pu.party_id = p_party_id
9017: AND pu.party_usage_code = c_supplier_code
9018: AND ROWNUM = 1;
9019: