3826:
3827: --
3828: select merge_reason_code
3829: into l_merge_reason_code 3830: from hz_merge_batch 3831: where batch_id = p_batch_id;
3832:
3833: if l_merge_reason_code = 'DUPLICATE' then
3834: -- if reason code is duplicate then allow the party merge to happen without