APPS.CS_SR_PARTY_MERGE_PKG dependencies on HZ_MERGE_BATCH

Line 79: FROM hz_merge_batch

75:
76:
77: SELECT merge_reason_code
78: INTO l_merge_reason_code
79: FROM hz_merge_batch
80: WHERE batch_id = p_batch_id;
81:
82: IF l_merge_reason_code = 'DUPLICATE' THEN
83: -- if reason code is duplicate then allow the party merge to happen without

Line 334: FROM hz_merge_batch

330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331:
332: SELECT merge_reason_code
333: INTO l_merge_reason_code
334: FROM hz_merge_batch
335: WHERE batch_id = p_batch_id;
336:
337: IF l_merge_reason_code = 'DUPLICATE' then
338: -- if reason code is duplicate then allow the party merge to happen without

Line 607: FROM hz_merge_batch

603: x_return_status := FND_API.G_RET_STS_SUCCESS;
604:
605: SELECT merge_reason_code
606: INTO l_merge_reason_code
607: FROM hz_merge_batch
608: WHERE batch_id = p_batch_id;
609:
610: IF l_merge_reason_code = 'DUPLICATE' THEN
611: -- if reason code is duplicate then allow the party merge to happen without

Line 909: from hz_merge_batch

905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: select merge_reason_code
908: into l_merge_reason_code
909: from hz_merge_batch
910: where batch_id = p_batch_id;
911:
912: if l_merge_reason_code = 'DUPLICATE' then
913: -- if reason code is duplicate then allow the party merge to happen without

Line 1076: from hz_merge_batch

1072: x_return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: select merge_reason_code
1075: into l_merge_reason_code
1076: from hz_merge_batch
1077: where batch_id = p_batch_id;
1078:
1079: if l_merge_reason_code = 'DUPLICATE' then
1080: -- if reason code is duplicate then allow the party merge to happen without

Line 1215: from hz_merge_batch

1211: ---dbms_output.put_line('am going to get reason code');
1212:
1213: select merge_reason_code
1214: into l_merge_reason_code
1215: from hz_merge_batch
1216: where batch_id = p_batch_id;
1217:
1218: ---l_merge_reason_code := null;
1219: --dbms_output.put_line('got reason code');

Line 1615: FROM hz_merge_batch

1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612:
1613: SELECT merge_reason_code
1614: INTO l_merge_reason_code
1615: FROM hz_merge_batch
1616: WHERE batch_id = p_batch_id;
1617:
1618:
1619: --dbms_output.put_line('gping to get merged id for ct id');

Line 2013: FROM hz_merge_batch

2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010:
2011: SELECT merge_reason_code
2012: INTO l_merge_reason_code
2013: FROM hz_merge_batch
2014: WHERE batch_id = p_batch_id;
2015:
2016: IF l_merge_reason_code = 'DUPLICATE' THEN
2017: -- if reason code is duplicate then allow the party merge to happen without