APPS.JTF_TERR_MERGE_PUB SQL Statements

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

Line: 63

          UPDATE jtf_terr_values_all jtv
          SET jtv.low_value_char_id = p_to_fk_id
            , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
            , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
            , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
            WHERE jtv.low_value_char_id = p_from_FK_id
            AND EXISTS (
                SELECT jtq.terr_qual_id
                FROM jtf_terr_qual_all jtq
                WHERE jtq.qual_usg_id IN (-1511, -1435, -1078, -1064, -1063, -1037, -1014, -1002, -1001, -1201, -1094, -1039)
                  AND jtq.terr_qual_id = jtv.terr_qual_id
            );

Line: 147

          UPDATE jtf_terr_values_all jtv
          SET jtv.low_value_char_id = p_to_fk_id
            , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
            , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
            , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
          WHERE jtv.low_value_char_id = p_from_FK_id
            AND EXISTS (
                SELECT jtq.terr_qual_id
                FROM jtf_terr_qual_all jtq
                WHERE jtq.qual_usg_id IN (-1094, -1093, -1077, -1039, -1005, -1201, -1094)
                  AND jtq.terr_qual_id = jtv.terr_qual_id
            );