665: IF p_from_fk_id <> p_to_fk_id THEN
666: BEGIN
667: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
668: -- Following lines of code is added by ptendulk on 14-May-2001
669: -- to do the party merge for table ams_iba_postings_b
670: UPDATE AMS_IBA_POSTINGS_B
671: SET customer_party_id = p_to_fk_id,
672: last_update_date = hz_utility_pub.last_update_date,
673: last_updated_by = hz_utility_pub.user_id,
666: BEGIN
667: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
668: -- Following lines of code is added by ptendulk on 14-May-2001
669: -- to do the party merge for table ams_iba_postings_b
670: UPDATE AMS_IBA_POSTINGS_B
671: SET customer_party_id = p_to_fk_id,
672: last_update_date = hz_utility_pub.last_update_date,
673: last_updated_by = hz_utility_pub.user_id,
674: last_update_login = hz_utility_pub.last_update_login
773: IF p_from_fk_id <> p_to_fk_id THEN
774: BEGIN
775: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
776: -- Following lines of code is added by ptendulk on 14-May-2001
777: -- to do the party merge for table ams_iba_postings_b
778: UPDATE AMS_IBA_POSTINGS_B
779: SET affiliate_party_id = p_to_fk_id,
780: last_update_date = hz_utility_pub.last_update_date,
781: last_updated_by = hz_utility_pub.user_id,
774: BEGIN
775: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
776: -- Following lines of code is added by ptendulk on 14-May-2001
777: -- to do the party merge for table ams_iba_postings_b
778: UPDATE AMS_IBA_POSTINGS_B
779: SET affiliate_party_id = p_to_fk_id,
780: last_update_date = hz_utility_pub.last_update_date,
781: last_updated_by = hz_utility_pub.user_id,
782: last_update_login = hz_utility_pub.last_update_login