APPS.POS_VENDOR_REG_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 465: UPDATE hz_party_usg_assignments

461: , g_module || '.' || l_method
462: , l_step);
463: END IF;
464:
465: UPDATE hz_party_usg_assignments
466: SET effective_end_date=sysdate,
467: status_flag = 'I',
468: last_updated_by = fnd_global.user_id,
469: last_update_date = Sysdate,

Line 1474: from hz_party_usg_assignments

1470: /* set the status of the party created to 'I' */
1471:
1472: select count(*)
1473: into l_party_usages
1474: from hz_party_usg_assignments
1475: where party_id = (select vendor_party_id
1476: from pos_supplier_registrations
1477: where supplier_reg_id = p_supplier_reg_id);
1478:

Line 1495: UPDATE hz_party_usg_assignments

1491: end if;
1492:
1493: /* set party_usage_code SUPPLIER_PROSPECT as inactive */
1494:
1495: UPDATE hz_party_usg_assignments
1496: SET effective_end_date=sysdate,
1497: status_flag = 'I',
1498: last_update_date = Sysdate,
1499: last_updated_by = fnd_global.user_id,