994: AND (party_id, pk1_value) IN
995: (SELECT fromparty.party_id,
996: merge_from_entity_id
997: FROM hz_merge_party_details site,
998: hz_party_sites fromparty,
999: hz_party_sites toparty,
1000: hz_merge_parties batch
1001: WHERE fromparty.party_site_id = merge_from_entity_id
1002: AND toparty.party_site_id = merge_to_entity_id
995: (SELECT fromparty.party_id,
996: merge_from_entity_id
997: FROM hz_merge_party_details site,
998: hz_party_sites fromparty,
999: hz_party_sites toparty,
1000: hz_merge_parties batch
1001: WHERE fromparty.party_site_id = merge_from_entity_id
1002: AND toparty.party_site_id = merge_to_entity_id
1003: AND batch.batch_id = p_batch_id
1018: AND (party_id, pk1_value) IN
1019: (SELECT fromparty.party_id,
1020: merge_from_entity_id
1021: FROM hz_merge_party_details site,
1022: hz_party_sites fromparty,
1023: hz_party_sites toparty,
1024: hz_merge_parties batch
1025: WHERE fromparty.party_site_id = merge_from_entity_id
1026: AND toparty.party_site_id = merge_to_entity_id
1019: (SELECT fromparty.party_id,
1020: merge_from_entity_id
1021: FROM hz_merge_party_details site,
1022: hz_party_sites fromparty,
1023: hz_party_sites toparty,
1024: hz_merge_parties batch
1025: WHERE fromparty.party_site_id = merge_from_entity_id
1026: AND toparty.party_site_id = merge_to_entity_id
1027: AND batch.batch_id = p_batch_id
2847: ELSIF (p_data_level_id = 17702) THEN
2848: BEGIN
2849: SELECT party_id
2850: INTO l_party_id
2851: FROM hz_party_sites
2852: WHERE party_site_id = p_to_party_id;
2853:
2854: EXCEPTION
2855: WHEN no_data_found THEN
3572:
3573: BEGIN
3574: SELECT party_id
3575: INTO l_party_id
3576: FROM hz_party_sites
3577: WHERE party_site_id = p_to_party_id;
3578:
3579: EXCEPTION
3580: WHEN no_data_found THEN