APPS.FUN_PARTY_MERGE_PUB dependencies on HZ_MERGE_BATCH

Line 50: FROM hz_merge_batch

46: --check the merge reason, if merge reason is 'Duplicate Record' then no validation is performed.
47: --otherwise check if the resource is being used somewhere
48: SELECT merge_reason_code
49: INTO l_merge_reason_code
50: FROM hz_merge_batch
51: WHERE batch_id = p_batch_id;
52:
53: IF l_merge_reason_code = 'DUPLICATE' THEN
54: -- if reason code is duplicate then allow the party merge to happen without

Line 174: FROM hz_merge_batch

170: --check the merge reason, if merge reason is 'Duplicate Record' then no validation is performed.
171: --otherwise check if the resource is being used somewhere
172: SELECT merge_reason_code
173: INTO l_merge_reason_code
174: FROM hz_merge_batch
175: WHERE batch_id = p_batch_id;
176:
177: IF l_merge_reason_code = 'DUPLICATE' THEN
178: -- if reason code is duplicate then allow the party merge to happen without

Line 289: FROM hz_merge_batch

285: --check the merge reason, if merge reason is 'Duplicate Record' then no validation is performed.
286: --otherwise check if the resource is being used somewhere
287: SELECT merge_reason_code
288: INTO l_merge_reason_code
289: FROM hz_merge_batch
290: WHERE batch_id = p_batch_id;
291:
292: IF l_merge_reason_code = 'DUPLICATE' THEN
293: -- if reason code is duplicate then allow the party merge to happen without

Line 404: FROM hz_merge_batch

400: --check the merge reason, if merge reason is 'Duplicate Record' then no validation is performed.
401: --otherwise check if the resource is being used somewhere
402: SELECT merge_reason_code
403: INTO l_merge_reason_code
404: FROM hz_merge_batch
405: WHERE batch_id = p_batch_id;
406:
407: IF l_merge_reason_code = 'DUPLICATE' THEN
408: -- if reason code is duplicate then allow the party merge to happen without

Line 516: FROM hz_merge_batch

512: --check the merge reason, if merge reason is 'Duplicate Record' then no validation is performed.
513: --otherwise check if the resource is being used somewhere
514: SELECT merge_reason_code
515: INTO l_merge_reason_code
516: FROM hz_merge_batch
517: WHERE batch_id = p_batch_id;
518:
519: IF l_merge_reason_code = 'DUPLICATE' THEN
520: -- if reason code is duplicate then allow the party merge to happen without