APPS.FEM_PARTY_PROFIT_MERGE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38

    not exist, we will just update the "From" Party_ID to the new Party ID
    *******************************************************************************/

   IF p_from_FK_id <> p_to_FK_id THEN

      IF p_parent_entity_name = 'HZ_PARTIES' THEN

         /*delete the existing target party ID  */
         DELETE FROM FEM_PARTY_PROFITABILITY
         WHERE party_id = p_To_Fk_id;

Line: 50

         /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE FEM_PARTY_PROFITABILITY
         SET party_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE party_id = p_From_FK_id;