APPS.ISC_DEPOT_PARTY_MERGE_PKG dependencies on HZ_MERGE_BATCH

Line 15: l_merge_reason_code hz_merge_batch.merge_reason_code%type;

11: p_batch_party_id in number,
12: p_return_status in out nocopy varchar2)
13: IS
14:
15: l_merge_reason_code hz_merge_batch.merge_reason_code%type;
16:
17: BEGIN
18:
19: arp_message.set_line('ISC_DEPOT_PARTY_MERGE_PKG.REPAIR_ORDERS_F_M()+');

Line 25: FROM hz_merge_batch

21: p_return_status := FND_API.G_RET_STS_SUCCESS;
22:
23: SELECT merge_reason_code
24: INTO l_merge_reason_code
25: FROM hz_merge_batch
26: WHERE batch_id = p_batch_id;
27:
28: IF l_merge_reason_code = 'DUPLICATE' THEN
29: -- if reason code is duplicate then allow the party merge to happen without