APPS.GL_ELIM_ACCOUNTS_MAP_PKG SQL Statements

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

Line: 24

      SELECT 1
      FROM DUAL
      WHERE EXISTS (SELECT 1
                    FROM   GL_ELIM_ACCOUNTS_MAP
                    WHERE  journal_id   = X_journal_id
                    AND    line_number  = X_lineno
                    AND   (rowid <> X_rowid OR X_rowid IS NULL));

Line: 83

     SELECT 1
     FROM DUAL
     WHERE EXISTS (SELECT 1
                   FROM   GL_ELIM_ACCOUNTS_MAP
                   WHERE  journal_id         = X_journal_id
                   AND   (rowid <> X_row_id OR X_row_id IS NULL)
                   AND   nvl(source_segment1, ' ') = nvl(X_ss1, ' ')
                   AND   nvl(source_segment2, ' ') = nvl(X_ss2, ' ')
                   AND   nvl(source_segment3, ' ') = nvl(X_ss3, ' ')
                   AND   nvl(source_segment4, ' ') = nvl(X_ss4, ' ')
                   AND   nvl(source_segment5, ' ') = nvl(X_ss5, ' ')
                   AND   nvl(source_segment6, ' ') = nvl(X_ss6, ' ')
                   AND   nvl(source_segment7, ' ') = nvl(X_ss7, ' ')
                   AND   nvl(source_segment8, ' ') = nvl(X_ss8, ' ')
                   AND   nvl(source_segment9, ' ') = nvl(X_ss9, ' ')
                   AND   nvl(source_segment10,' ') = nvl(X_ss10,' ')
                   AND   nvl(source_segment11,' ') = nvl(X_ss11,' ')
                   AND   nvl(source_segment12,' ') = nvl(X_ss12,' ')
                   AND   nvl(source_segment13,' ') = nvl(X_ss13,' ')
                   AND   nvl(source_segment14,' ') = nvl(X_ss14,' ')
                   AND   nvl(source_segment15,' ') = nvl(X_ss15,' ')
                   AND   nvl(source_segment16,' ') = nvl(X_ss16,' ')
                   AND   nvl(source_segment17,' ') = nvl(X_ss17,' ')
                   AND   nvl(source_segment18,' ') = nvl(X_ss18,' ')
                   AND   nvl(source_segment19,' ') = nvl(X_ss19,' ')
                   AND   nvl(source_segment20,' ') = nvl(X_ss20,' ')
                   AND   nvl(source_segment21,' ') = nvl(X_ss21,' ')
                   AND   nvl(source_segment22,' ') = nvl(X_ss22,' ')
                   AND   nvl(source_segment23,' ') = nvl(X_ss23,' ')
                   AND   nvl(source_segment24,' ') = nvl(X_ss24,' ')
                   AND   nvl(source_segment25,' ') = nvl(X_ss25,' ')
                   AND   nvl(source_segment26,' ') = nvl(X_ss26,' ')
                   AND   nvl(source_segment27,' ') = nvl(X_ss27,' ')
                   AND   nvl(source_segment28,' ') = nvl(X_ss28,' ')
                   AND   nvl(source_segment29,' ') = nvl(X_ss29,' ')
                   AND   nvl(source_segment30,' ') = nvl(X_ss30,' '));